Help with IF calculation
here is the formual but I keep getting an error can anybody help me pleassssse! Thanks! :confused: :eek: =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! :confused: :eek: =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 |
All times are GMT +1. The time now is 10:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com