View Single Post
  #3   Report Post  
Bill Kuunders
 
Posts: n/a
Default

Not God but
"AX" should work.... with the ""

--
Greetings from New Zealand
Bill K
"TB via OfficeKB.com" wrote in message
...
I am trying to update a spreadsheet with if statements. I have done well
in
the past but this one is puzzling. I am trying the following statement
=IF
(B7=AX,F7*2.95%,"NA") and it isn't working. It will work fine if I
replace
the AX with numeric characters. Does any of the Excel gods know how I can
either fix this or have a work around?

Thanks!!!!