0.25
 

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="fl expart",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?

0.25
 

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



Gator Girl wrote:

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="fl expart",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

0.25
 

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

"Gator Girl" wrote:

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="fl expart",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?

0.25
 

EUREKA - and THANK YOU! Problem solved.

"Dave Peterson" wrote:

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



Gator Girl wrote:

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="fl expart",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

0.25
 

Glad you got it fixed.

(I saw your earlier celebration post!)

Gator Girl wrote:

EUREKA - and THANK YOU! Problem solved.

"Dave Peterson" wrote:

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



Gator Girl wrote:

The formula in cell G22 reads:
=IF(O22="FLEX",V22,IF(O22="HOLIDAY",V22,IF(O22="fl expart",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


--

Dave Peterson