Thread: 0.25
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gator Girl Gator Girl is offline
external usenet poster
 
Posts: 36
Default 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?