"The formula you typed contains an error" returned with multiple IF formula

[roba730]

My data has a number in column 2 that I need to analyze against multiple criteria and return a value based on the analysis. In basic terms I need to look at the value in Column 2 and if the value is less than 2077, return A. If the number is 2077 or more but less than 10,000, return B. If the number is 10,000 or more but less than 27027, return C. If it is 27027 or more return D.

I created this multiple IF formula.

=IF(C2<2077,a,IF(C2<10000,b,IF(C2<27027,c,d)))

however it returns error in the title above.

Thanks in advance for the assistance.

 

[mumps]

Try: =IF(C2<2077,"A",IF(AND(C2>2077,C2<10000),"B",IF(AND(C2>10000,C2<27027),"C","D")))
You have to test for lower and upper limits. Also consider what happens if the value in C2 is equal to 27077 or 10000 or 27027. You may have to use >= or <= in places in the formula. Also the values returned have to be in quotes.