LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
A. Blundon
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A search for $ in a formula use to work now it does not work JuneJuly Excel Discussion (Misc queries) 2 November 30th 05 10:13 PM
formulas don't work anymore john Excel Discussion (Misc queries) 3 November 18th 05 04:11 PM
Moving a sheet from one work book to another? WTG Excel Worksheet Functions 1 November 3rd 05 07:12 PM
My links no longer work . . . mike Excel Discussion (Misc queries) 8 October 27th 05 11:59 PM
How to get saved old saved work that was saved over? Maral Excel Discussion (Misc queries) 1 February 20th 05 08:59 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"