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