N/A Error

[Rich]

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]

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

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

Regards,
Fred.

 

[JE McGimpsey]

One way:

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

 

[JE McGimpsey]

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

 

[Rich]

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

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

Regards,
Fred.



Thank you