Thread: #N/A

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

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

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Freddo" <Freddo@discussions.microsoft.com> wrote in message
news:938EC22F-E9AC-42F9-9FBB-D886E01A510F@microsoft.com...
> 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 "" 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","-")
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Freddo" wrote:

> 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)),"No", VLOOKUP(A1,
$A$4:$B$10,2,FALSE))
--
Kevin Vaughn


"Freddo" wrote:

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