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.
You can try below:
=CONCATENATE(IF(AND(C11<=5