Hi, Can anyone help me with stringing the following IF statements together into one long IF statement: This is the order I'd like them, obviously the =IF will disappear from the 2nd two statements. I can get them to work in isolation but not as one. Keep getting missing parenthesise message. Basically I'd like, IF J2 doesn't equal "Ip" then execute statement A otherwise execute statement B
=IF(J2<>"Ip",
A
=IF(J4<199,$C$14,IF(AND(J4>=200,J4<=299),$D$14,IF(AND(J4>=300,J4<=399),$E$14,IF(AND(J4>=400,J4<=499),$F$14,IF(AND(J4>=500,J4<=599),$G$14,IF(AND(J4>=600,J4<=699),$H$14,IF(AND(J4>=700,J4<=799),$I$14,IF(AND(J4>=800,J4<=899),$J$14,IF(AND(J4>=900,J4<=999),$K$14,IF(AND(J4>=1000,J4<=1099),$L$14,IF(AND(J4>=1100,J4<=1199),$M$14,IF(AND(J4>=1200,J4<=1299),$N$14))))))))))))
B
=IF(AND(J4>=150,J4<=390),$R$16,IF(AND(J4>390,J4<570),$S$16,IF(AND(J4>=570,J4<660),$T$16,IF(AND(J4>=660,J4<750),$U$16,IF(AND(J4>=750,J4<840),$V$16,IF(AND(J4>=840,J4<1110),$W$16,IF(J4>=1110,$X$16)))))))
=IF(J2<>"Ip",
A
=IF(J4<199,$C$14,IF(AND(J4>=200,J4<=299),$D$14,IF(AND(J4>=300,J4<=399),$E$14,IF(AND(J4>=400,J4<=499),$F$14,IF(AND(J4>=500,J4<=599),$G$14,IF(AND(J4>=600,J4<=699),$H$14,IF(AND(J4>=700,J4<=799),$I$14,IF(AND(J4>=800,J4<=899),$J$14,IF(AND(J4>=900,J4<=999),$K$14,IF(AND(J4>=1000,J4<=1099),$L$14,IF(AND(J4>=1100,J4<=1199),$M$14,IF(AND(J4>=1200,J4<=1299),$N$14))))))))))))
B
=IF(AND(J4>=150,J4<=390),$R$16,IF(AND(J4>390,J4<570),$S$16,IF(AND(J4>=570,J4<660),$T$16,IF(AND(J4>=660,J4<750),$U$16,IF(AND(J4>=750,J4<840),$V$16,IF(AND(J4>=840,J4<1110),$W$16,IF(J4>=1110,$X$16)))))))