0.25


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

Advertisements

D

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

Guest

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

Guest

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

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top