Thread: #N/A
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hanr3
 
Posts: n/a
Default #N/A

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