Excel 2007 : if cell equals text or text, then...

[mcinfo]

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!

[Palmetto]

=IF(OR(A1="x",LEN(A1)=0),"N/A","Missing")

I also thought maybe apostrophes are needed instead of quotes, I never know which to use

Quotes are required whenever you need to return a text string and not the result of cell or calculation

[mcinfo]

It says the formula you typed contains and error, and it highlights the ""x",LEN(" section of the it...
am i doing something wrong?

[darkyam]

It seems that both the first formula you had and Palmetto's offering should work. Without seeing the worksheet (which would help, if you can post it with dummy data), my first question is whether the value in A1 comes from a database or other program. In such cases, those cells will often have spaces in them. When you do =Len(A1) in another cell, with A1 looking like it's blank, what result do you get?