Hello, I'm trying to make a formula in excel 2007, where if for instance A1 equals "x" or is empty, then B2 would display "N/A", otherwise it would display "missing".
So if the cells in column A contain either x or are completely empty, the corresponding cells in column B would show N/A. if the cells in column A contain anything else, the corresponding cells in B would display "missing".
this is what I tried so far:
=IF(OR(A1="x", A1=""), "N/A", "missing")
I also thought maybe apostrophes are needed instead of quotes, I never know which to use and when:
=IF(OR(A1='x', A1=''), 'N/A', 'missing')

thanks a lot in advance!