C
Cameron
This would work. If A1 is empty or doesn't work, it will
insert the word "hello". Take "hello" out of the formula
and enter in what you want to happen if A1 does not
have "one" or "two"
HTH
=IF(OR(A1="one",A1="two"),"-","hello")
insert the word "hello". Take "hello" out of the formula
and enter in what you want to happen if A1 does not
have "one" or "two"
HTH
=IF(OR(A1="one",A1="two"),"-","hello")