Trouble with an IF statement.

C

Cerberus

I have a drop down in cell F37 that has the options AL88 and AL667. In cell
B93 I put an =IF(F37=AL88,2,0), but when cell F37 shows AL88, cell B93 is
showing 0. What did I do wrong?
 
J

JLatham

Don't feel too bad. I've given up keeping track of the times I added quote
marks around something when I shouldn't have, or of not using them when I
should have. And those are the kinds of things you have to almost come to a
complete halt during your debugging and go step by step to find, and usually
a couple of times to get it right. That's when another pair of eyes, such as
David's in this case, really come in handy: they don't see what they expect
to see, they see what is actually there.
 
Top