Forum Discussion
EXCEL WORKING
Dear Sir, Can I use multi-cell for calculation? For Example if A2=1.1 and C2=3 and D2=A and If Sum of L2 TO T2 > 40-F2-H2 Then Sum of L2 To R2 and if Sum Of L2 TO R2 > 40-F2-H2 then...
Not sure I understood entire logic, but if translate your condition literally that will be
=IF(( A2=1.1)*(C2=3)*(D2="A"), IF( SUM(L2:T2) > 40-F2-H2, IF(SUM(L2:R2) > 40-F2-H2, SUM(L2:P2), SUM(L2:N2))))