Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a simple formula that doesn't seem to work. In fact it gives me
the opposite answer I expect. Cell G43 has been named "Fy_Deck". I've typed a value of 235 into this cell. My formula (in cell I43) is this: =IF(Fy_Deck<=300,"NG","OK") The format for cell G43 is Number with 0 decimal places. The formula in I43 returns "OK". I would have expected that since 235 is less than or equal to 300, I would get a "NG". Any ideas? This seems to be happening in a couple of locations in my sheet. AB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
formulas don't work anymore | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |