Hi,
I am trying to enter the following formula however I know it has to many Nested Ifs but can't figure out a way round it:
=IF(OR(GS3="Y",P3=0),0,IF(AND(AC3<AB3,AJ3<AG3*1.5),0,IF(CV3>CU3,CV3,
IF(CU3>CT3,CU3,IF(CT3>CS3,CT3,IF(CS3>CR3,CS3,IF(CR3>CQ3,CR3,
IF(CQ3>CP3,CQ3,IF(CP3>CO3,CP3,IF(CO3>CN3,CO3,IF(CN3>CM3,CN3,
IF(CM3>CL3,CM3,IF(CL3>0,CL3,0))))))
I've tried to amend it by doing &IF but think I've went way off course with that. Can anyone point me in the right direction?
Many Thanks
Fraser
I am trying to enter the following formula however I know it has to many Nested Ifs but can't figure out a way round it:
=IF(OR(GS3="Y",P3=0),0,IF(AND(AC3<AB3,AJ3<AG3*1.5),0,IF(CV3>CU3,CV3,
IF(CU3>CT3,CU3,IF(CT3>CS3,CT3,IF(CS3>CR3,CS3,IF(CR3>CQ3,CR3,
IF(CQ3>CP3,CQ3,IF(CP3>CO3,CP3,IF(CO3>CN3,CO3,IF(CN3>CM3,CN3,
IF(CM3>CL3,CM3,IF(CL3>0,CL3,0))))))
I've tried to amend it by doing &IF but think I've went way off course with that. Can anyone point me in the right direction?
Many Thanks
Fraser