I have a worksheet function that looks like this IF(A1=1,"open","closed")
THe value of A1 will on ly be three things (0,1,???). So I'd like to make the formula to do this:
When A1 is 0, I want it to say "Closed"
When A1 is 1, I want it to say "Open"
When A1 is ???, I want it to just be blank (or it can also have "???", it just can't say Open or Closed.
THanks for any help.
de
THe value of A1 will on ly be three things (0,1,???). So I'd like to make the formula to do this:
When A1 is 0, I want it to say "Closed"
When A1 is 1, I want it to say "Open"
When A1 is ???, I want it to just be blank (or it can also have "???", it just can't say Open or Closed.
THanks for any help.
de