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


=if(j12<3,"",IF(J12=3,"0.52",If(j12=4,"0.62",If(j1 2=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")))))))))))


--
Wazza
------------------------------------------------------------------------
Wazza's Profile: http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202

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


2 ""
3 ".52"


etc


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=278202

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


"Wazza" wrote in message
...

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


=if(j12<3,"",IF(J12=3,"0.52",If(j12=4,"0.62",If(j1 2=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")))))))))))


--
Wazza
------------------------------------------------------------------------
Wazza's Profile:
http://www.excelforum.com/member.php...o&userid=16225
View this thread: http://www.excelforum.com/showthread...hreadid=278202