I have a drop down list with 3 possibilities:
Yes
No
"?*"
And then an if formula checking which is chosen:
"IF(A1=A2, 1, 2)
The Yes and No options work, but the wildcard one, which should mean any text, doesn't work. I want the third option (currently "?*") to be either yes or no.
Bookmarks