EXCEL WORKING

[Abdul_Naveed192000]

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 answae L2 To P2 otherwise sum of L2 TO N2

Also Sheet are Attached

please help me

[#2]

@Abdul_Naveed192000 

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))))