Thread: Trouble with an IF statement.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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?


Reply With QuoteReply With Quote