#N/A

[Freddo]

Is there any way you can change #N/A to show anything else eg No

 

[Peo Sjoblom]

=IF(ISNA(your_formula()),"No",your_formula))

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Hanr3]

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","-")

 

[Kevin Vaughn]

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))