0.25

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="flexpart",0,AL6)))
If AL6's value is .50 or greater, I get my desired result, but if the value
is .25, it won't show in G22.

How Come?
 
Any chance that the cell with the formula is using format|Conditional formatting
to hide "small" values?

If you select that formula cell, hit F2, hit F9
what do you see in the formula bar?

(Hit escape to get that formula back -- or edit|undo if you converted it to a
value.)
 
EUREKA! Problem solved. The value being returned was the unrounded value
of .24999999999.
THANK YOU SO MUCH!!!!
 
EUREKA - and THANK YOU! Problem solved.

Dave Peterson said:
Any chance that the cell with the formula is using format|Conditional formatting
to hide "small" values?

If you select that formula cell, hit F2, hit F9
what do you see in the formula bar?

(Hit escape to get that formula back -- or edit|undo if you converted it to a
value.)
Click to expand...
 
Back
Top