Mel, one other suggestion for blank.
Posted by
iSpam (aka spamlet)
Apr 23 '15, 04:27
|
You should be able to use two quotation marks with no spaces in between for blank.
if a1 = "", etc.
I dont know about current versions but in the past Excel (and Access) didn't always handle blanks well. What I would do is use the nested if and just have the blank as the false in your last if. That way you're not testing on blank but on your other values.
|
Responses:
|
