Thread: N/A Error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default N/A Error

Yes, check for N/A with an If statement, as in:

=if(iserror(your formula),"Incorrect",your formula)

Regards,
Fred.

"Rich" wrote in message
...
Hi All

Is it possible that when a Formula returns a N/A result, can I change this
to say "Incorrect" r something else of my choice.

cheers