If Statement Problem
 

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!!!!

Text must have quotes.
=IF(B7="AX",F7*.0295,"NA")
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"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!!!!

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!!!!