Problem in applying IF formula for 25 conditions

[pradeepm]

Dear all,
Please help me in putting the formula of IF in 25 conditions.

Attached Excel file for reference.

Regards,
Pradeep Moharana

 

[bosco_yip]

Hi,

Please use Sumifs function instead of 25 If function as per following set up.

In Result G3, enter formula:

=SUMIFS(C:C,A:A,E3,B:B,F3)

 

[pradeepm]

Hi,

Please use Sumifs function instead of 25 If function as per following set up.

In Result G3, enter formula:

=SUMIFS(C:C,A:A,E3,B:B,F3)

View attachment 82640

Dear Sir,
Thank you for your response.
But My query is " If A3=1 & B3=1 then the result should be 1.
Likewise in all the 25 conditions (C3=1,C4=3,C5=6) etc.

Can you please help me with the formula ?

Example formula i applied - =(IF(AND(U5>=1,V5<=1),"1",IF(AND(U5>=1,V5<=2),"3", IF(AND(U5>=1,V5<=3),"6", IF(AND(U5>=1,V5<=4),"10",IF(AND(U5>=1,V5<=5),"15", (After this its not calculating) IF(AND(U5>=2,V5<1),"2".

Attached Excel sheet for your reference.



Regards,
Pradeep Moharana

 

[bosco_yip]

Dear Sir,
Thank you for your response.
But My query is " If A3=1 & B3=1 then the result should be 1.
Likewise in all the 25 conditions (C3=1,C4=3,C5=6) etc.

Can you please help me with the formula ?

Example formula i applied - =(IF(AND(U5>=1,V5<=1),"1",IF(AND(U5>=1,V5<=2),"3", IF(AND(U5>=1,V5<=3),"6", IF(AND(U5>=1,V5<=4),"10",IF(AND(U5>=1,V5<=5),"15", (After this its not calculating) IF(AND(U5>=2,V5<1),"2".

Attached Excel sheet for your reference.



Regards,
Pradeep Moharana

Please google: "How to use SUMIFS functions?" before you ask any question.

Your post#1 question is solved. And "new thread for new question"

This thread is closed.

Regards