• 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.

pradeepm

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

Attached Excel file for reference.

Regards,
Pradeep Moharana
 

Attachments

  • IF Function Issue.xlsx
    16 KB · Views: 5
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
 
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

  • IF Function Issue.xlsx
    17.1 KB · Views: 3
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.
Back
Top