Home |
Search |
Today's Posts |
#3
![]() |
|||
|
|||
![]()
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!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statement Problem | Excel Worksheet Functions | |||
Problem with nested IF_OR statement | Excel Worksheet Functions | |||
Fundamental problem with IF statement | Excel Worksheet Functions | |||
Fundamental problem with IF statement | Excel Worksheet Functions | |||
IF statement problem | Excel Worksheet Functions |