View Single Post
  #1   Report Post  
Wazza
 
Posts: n/a
Default Help with IF calculation


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