Help with IF calculation

[Wazza]

here is the formual but I keep getting an error can anybody help m
pleassssse! Thanks!


=if(j12<3,"",IF(J12=3,"0.52",If(j12=4,"0.62",If(j12=5,"0.67",If(j12=6,"0.72",if(j12=7,"075",if(j12=8,"0.78",if(j12=9,"0.81",IF(j12>=10,"0.83",IF(j12=>15,"0.90",if(j12>=20,"0.95"))))))))))

 

[duane]

i suspect you have too many nested ifs. try doing it with a vlooku
table


2 ""
3 ".52"


et

 

[JulieD]

Hi

you're only "allowed" to nest seven other IFs in the False section of the
first IF and you've got 10

and BTW there's a couple of other problems too
J12=>15 , needs to be j12>=15 ... but it will never get here .. .as the
previous statement j12>=10 will "capture" anything over 10. (same for the
j12>=20 bit)
and by putting your values in " " you've made them text (e.g. "0.52").

you've basically two of your options are , you could create a separate list
(say in G1:H11) like
Value Result
3 0.52
4 0.62
5 0.67
6 0.72
7 0.75 'i'm assuming
8 0.78
9 0.81
10 0.83
15 0.90
20 0.95

and use a formula like
=IF(J12<3,"",VLOOKUP(J12,$G$1:$H$11,2))

OR you could embed the VLOOKUP table in the formula, e.g.
=IF(J12<3,"",VLOOKUP(J12,{3,0.52;4,0.62;5,0.67;6,0.72;7,0.75;8,0.78;9,0.81;10,0.83;15,0.9;20,0.95},2))

Hope this helps
Cheers
JulieD