N/A Error
"Fred Smith" wrote:
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
Thank you
|