Help again on an if nested formula
I would do it differently. You may care to try this:-
Build a simple table in (say) A1 to B6 with your conditions:-
0 0
40 17.30%
70 16.90%
75 13.60%
83.3 9.10%
Then a simple Vlookup looking at F7
=VLOOKUP(F7,A1:B6,2,TRUE)
Mike
"CBZ" wrote:
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
|