Yes, depends on the formula. However in the false answer for most formulas
put "" and it will leave the cell empty. I prefer to use "-". That way I know
the formual is working.
For example: IF(A2=3,"Yes","-")
If this formula returns #N/A:
=VLOOKUP(A1, $A$4:$B$10,2,FALSE)
Try changing it to this:
=IF(ISNA(VLOOKUP(A1, $A$4:$B$10,2,FALSE)),"No", VLOOKUP(A1,
$A$4:$B$10,2,FALSE))
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
