Trouble with an IF statement.
 

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?

Trouble with an IF statement.
 

You forgot the quote marks around the string "AL88"
--
David Biddulph

"Cerberus" wrote in message
...
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?

Trouble with an IF statement.
 

I feel stupid, Thanks for your help.

"David Biddulph" wrote:

You forgot the quote marks around the string "AL88"
--
David Biddulph

"Cerberus" wrote in message
...
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?

Trouble with an IF statement.
 

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.

"Cerberus" wrote:

I feel stupid, Thanks for your help.

"David Biddulph" wrote:

You forgot the quote marks around the string "AL88"
--
David Biddulph

"Cerberus" wrote in message
...
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?