=IF(OR(A1="x",LEN(A1)=0),"N/A","Missing")
Quotes are required whenever you need to return a text string and not the result of cell or calculationI also thought maybe apostrophes are needed instead of quotes, I never know which to use
=IF(OR(A1="x",LEN(A1)=0),"N/A","Missing")
Quotes are required whenever you need to return a text string and not the result of cell or calculationI also thought maybe apostrophes are needed instead of quotes, I never know which to use
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks