• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem in applying IF formula for 25 conditions

Status
Not open for further replies.

bosco_yip

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

82640
 

pradeepm

New Member
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
 

Attachments

bosco_yip

Excel Ninja
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
 
Last edited:
Status
Not open for further replies.
Top