Compaq / -

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.

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?

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.

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.

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.

I experiment with that tool, thanks for bringing it to my attention. Thanks again for your sage wisdom.

Ask Your Question

Weekly Poll

Do you think Google should sell budget phones in the US?

Discuss in The Lounge

Poll History