0

I want to return if its "NO" should return value of Mismatch and if the cell has number in it it should return "Duplicate and the number itself. But it is returning me the logical value. I am using this formula =IF(F4="NO","Mismatch",IF(F4=ISNUMBER(F4),"Duplicate"&F4))

Would really appreciate if you could guide me on this

enter image description here

Improve this question

1 Answer 1

Reset to default
0

"ISNUMBER" returns True or False, you don't want to test if F4 = that result as that will always be untrue unless F4 actually contains a logical "FALSE" value. Also, your second IF function does not define what to display if F4 is neither No nor a number. Blank perhaps? Try

=IF(F4="NO","Mismatch",IF(ISNUMBER(F4),"Duplicate "&F4,""))

(note the space after "Duplicate" for improved appearance).

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .