Look again at your formula.

You've tested initially against 0.8 (i.e. 80%). If E7 is greater than that
you get your 9.1% result.
If E7 is less than 0.8 you then test it for being greater than 75, 70, 40,
and 10 in turn, none of which can be true if it is less than 0.8, so the
answer FALSE is what you've asked for.
--
David Biddulph

"CBZ" wrote in message
...
Any idea guys... I have a bus. case due for 2pm and really could benefit
from
your expertise and help.

Celeste

"CBZ" wrote:

Don, we are getting there... I am using the folowing:

=IF(E70.8,0.091,IF(E7=75,0.136,IF(E770,0.169,IF (E740,0.173,IF(E710,0.19)))))

however when E7 is 83% it is returning 9.1% - perfect but when E7 reads
71.3% it is returning "false" vs. 16.9%

Celeste
"Don Guillett" wrote:


how about
if(f7=.8,.091,if(f7=.75,.136,if(etc
--
Don Guillett
SalesAid Software

"CBZ" wrote in message
...
CAn someone detect what I am doing wrong on the following formula:


=IF(F7=40%<=70%,"17.3%",IF(F770%<=75%,"16.9%",IF (F7=75%<=80%,"13.6%",IF(F7=80%<=100%,"9.1%",0))) )

Ideally if the ref cell (f7) has 83.2% I want 13.6% returned.

Thanks so much.

Celeste