# Excel-Combing 2NestedIFs+Conditions

Compaq / -
February 12, 2009 at 10:51:40
Specs: Windows XP, 1GB
 Hello Friends. Got another question for you.I want to know how to combine 2 Nested IF functions in excel into one cell with a condition before each of them.And to throw in another twist if you just simply combine these 2 formulas there will be 8 nested IFs which cant happen since im using an older version of excel. But the last IF on each of the formulas are the same so...: Is it possible to combine these formulas and still have the last IF function: IF(AND(A1>1000,A1<100000),"RCS" absolute?Desired result: When cell A2 has "Condition1" use formula 1. When cell A2 has "Condition2" use formula 2.Here is formula1:=IF(AND(A1>0,A1<41),40,IF(AND(A1>40,A1<61),60,IF(AND(A1>60,A1<1001),100,IF(AND(A1>1000,A1<100000),"RCS"))))Here is formula2:=IF(AND(A1>0,A1<21),20,IF(AND(A1>20,A1<51),50,IF(AND(A1>50,A1<1001),100,IF(AND(A1>1000,A1<100000),"RCS"))))Looking forward to your response.

See More: Excel-Combing 2NestedIFs+Conditions

#1
February 12, 2009 at 13:14:21
 Here's a lazy solution:Put the 2 Nested If's in separate cells and then use a simple If statement based on Condition 2 to get the final answer.Or...Have you tried putting the RCS part first so that it never looks at A2? Would that get you down to less than 7 If's?

Report •

#2
February 12, 2009 at 13:19:56
 DerbyDad03 - Ill give each suggestion a try. I can see how the lazy solution would work.But im going to try the 2nd solution just because I want to learn more about it. Thanks again. Ill let you know what I come up with.

Report •

#3
February 19, 2009 at 13:47:02
 Just a little follow up on this I got the formula to work the way I wanted and learned in the process. Just wanted to update and thank you for the help.

Report •

Related Solutions

#4
February 19, 2009 at 14:33:10
 Thanks for the feedback.BTW the Evaluate Formula feature under Tools...Formula Auditing can be useful in finding problems with complex formulae.For example, you can single step through your Nested IF and see the True's and False's as each IF is evaluated.

Report •

#5
February 19, 2009 at 15:39:13
 I experiment with that tool, thanks for bringing it to my attention. Thanks again for your sage wisdom.

Report •