software

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

=IF(ISNA(your_formula()),quot;Noquot;,your_formula))

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Freddoquot; gt; wrote in message
...
gt; Is there any way you can change #N/A to show anything else eg No
Yes, depends on the formula. However in the false answer for most formulas
put quot;quot; and it will leave the cell empty. I prefer to use quot;-quot;. That way I know
the formual is working.
For example: IF(A2=3,quot;Yesquot;,quot;-quot;)
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.quot;Freddoquot; wrote:

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

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)),quot;Noquot;, VLOOKUP(A1,
$A$4:$B$10,2,FALSE))
--
Kevin Vaughnquot;Freddoquot; wrote:

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