IF cell empty return N/A, otherwise value as written in cell

[Keithhe]

Trying to write a formula in a cell to check another cell.

Goal

Have cell A2 check value in A1

IF A1 is empty, return "n/a" in A2 otherwise return the exact value in A1 to A2.

Seemed easy enough, but nothing I've tried seems to work.

Thanks,

Keith

[BadlySpelledBuoy]

In A2:

=IF(A1="","N/A",A1)

BSB

[Keithhe]

Thanks for that, and although close not working?

That returns "n/a" if empty or filled??

[BadlySpelledBuoy]

Have you got auto calculation turned off?

Perhaps attach the workbook so we can see in context. It should work as the formula in plain English says "if A1 has no value show N/A, else show the content of A1"

BSB

[JohnTopley]

What is in A1?

If it is a formula, try

=IF(A1=0,"N/A",A1)

[Keithhe]

Sorry, I was wrong and your formula was correct and works !!!

I checked and I had a typo. Thank you !!

Keith

[BadlySpelledBuoy]

No problem. Happy to help

BSB