View Single Post
  #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