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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.