N/A Error

Rich · May 12, 2008

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

Fred Smith · May 12, 2008

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

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

Regards,
Fred.

JE McGimpsey · May 12, 2008

One way:

=IF(ISNA(<your formula>),"incorrect",<your formula>)

JE McGimpsey · May 12, 2008

Not the best way - ISERROR() will mask other errors besides N/A. Better
to use ISNA() instead.

Rich · May 12, 2008

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

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

Regards,
Fred.

Thank you