Excel - "if this then that" question

[AlP]

Good afternoon all,

I am still new to using formulas, but here is what I need help on. IF cell A9 shows "#N/A", is there a way I can have cell B9 to show "THIS IS NOT A STANDARD". Please help.

Thanks you,
ALP

[crispbd]

In Cell B9 put:

=IF(ISNA(A9),"THIS IS NOT A STANDARD","")

[AlP]

Thank you very much. This really helps.