Hi, I'm trying to use the IF-AND formula to return an value from two cells in excel but can't get it to work so could someone take a look and advise please? So far I have got - =IF((AND (E4 =2,F4<0.6),45, IF((AND (E4 =2,F4>0.6),60, IF((AND (E4 =2,F4>1),85, IF((AND (E4 =1, F4<0.1),12, IF((AND (E4 =1, F4<0.15),15, IF((AND (E4 =1, F4<0.175),18, IF((AND (E4 =1, F4>0.176),24, IF((AND (E4 =Courier, F4<0.1),12, IF((AND (E4 =Courier, F4 <0.15),15, IF((AND (E4 =Courier, F4 <0.175),18, IF((AND (E4 =Courier, F4 >0.176),24))))))))))))))))))))))
Solved by A. L. in 22 mins