Posted to microsoft.public.excel.misc
|
|
Help again on an if nested formula
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
|