0.25

[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?

 

[Dave Peterson]

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.)

 

[Guest]

EUREKA! Problem solved. The value being returned was the unrounded value
of .24999999999.
THANK YOU SO MUCH!!!!

 

[Guest]

EUREKA - and THANK YOU! Problem solved.

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.)

 

[Dave Peterson]

Glad you got it fixed.

(I saw your earlier celebration post!)