troubleshooting Question

Multiple (nested?) IF statements with AND / please help - Too many arguments

Avatar of Adrian McNair
Adrian McNair asked on
Microsoft ExcelMicrosoft Office
8 Comments2 Solutions321 ViewsLast Modified:
I am trying to get this working, but getting too many arguments. I have tried searching on the forum and there are many entries, but have not found any with the use of multiple AND's

C11 is a number entry by the user. C12 is drop down with yes and no.
Based on the value of C11 that is entered and C12 (yes/No) selection , I want to display A1 through A6.
C11 value ranges that I need are :  <=500, between 500 & 2999 and >= 3000

This is the formula that I put in & 
=IF(AND(C11<=500,C12="yes"),A4,A1,       IF(AND(C11>500,C11<3000,C12="yes"),A5,A2,      IF(AND(C11>=3000,C12="yes"),A6,A3)))

PS: I have put some spacing between IF statements just to show some separation.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros