I have a validation list list in column E "Check, Charge, Credit Card, Other".
in another column i have what i thought was a straight forward IF statement: =if(E3="Check",9999,"[ ]")
It does not recognize "Check" as the condition. Is there a tweak i can do to get it recognize the data validation.
Thanks
Bookmarks