Thread
:
Help again on an if nested formula
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Help again on an if nested formula
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett