Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formala Doesn't Work
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formala Doesn't Work
Hi
This works for me. Check that Calculation is set to Automatic in Tools/Options/Calculation tab Andy. "A. Blundon" wrote in message ups.com... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formala Doesn't Work
Calculation is set to automatic. Also I tried hiting F9 a so see if it
would recalc. Still no luck. Thanks, AB |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formala Doesn't Work
Make sure, then, that G43 is formatted as General. If it is text, it will
give you the result you have. Set the format and then re-enter 235. AndyB "A. Blundon" wrote in message oups.com... Calculation is set to automatic. Also I tried hiting F9 a so see if it would recalc. Still no luck. Thanks, AB |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Formala Doesn't Work
This works correctly for me as well. I don't know why it isn't working for
you, but heres some things to try. Retype the number 235 in G43. If originally entered as text, changing format to number may not change it until retyped. What happens if you enter a number greater than 300? Does "OK" or "NG" show up? What about other numbers? Does it ever change? Do you have any Macros or VB code in your workbook? I have myself stopped using code before, then forgotten about it, until weird results started showing up later. Recreate this in a new workbook and see what happens. If it works, this may give you an indication whether it is an Excel setting, or a Workbook setting that is causing the problem. HTH, Elkar "A. Blundon" wrote: Calculation is set to automatic. Also I tried hiting F9 a so see if it would recalc. Still no luck. Thanks, AB |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |