N/A Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich - 12 May 2008 04:40 GMT

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

Reply to this Message

Fred Smith - 12 May 2008 05:31 GMT

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

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

Regards,
Fred.

> 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

Reply to this Message

JE McGimpsey - 12 May 2008 05:34 GMT

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

> Yes, check for N/A with an If statement, as in:
>
> =if(iserror(your formula),"Incorrect",your formula)

Reply to this Message

Rich - 12 May 2008 05:40 GMT

> Yes, check for N/A with an If statement, as in:
>
[quoted text clipped - 11 lines]
>
> Thank you

Reply to this Message

JE McGimpsey - 12 May 2008 05:33 GMT

One way:

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

> 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

Reply to this Message

Rate this thread: