N/A Error
 

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

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

N/A Error
 

One way:

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

In article ,
Rich wrote:

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

N/A Error
 

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

In article ,
"Fred Smith" wrote:

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

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

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