Lots of "IFs" in an If statement

[Excel1991]

Good Afternoon,

I was hoping that the forum may be able to help me with amultilevel “IF” function. I do not think it would be very complicated but I can’tquite nail down the formula.
What I would like to do is have the formula display thefollowing:

• If cellA1 is greater than $30,000 assign it an “A”
  
• If cell A1 is greater than or equal to 15k butless than 30k, assign it a “B”
  
• If cell A1 is greater than or equal to 6k butless than 15k, assign it a “C”
  
• For any value less than 6k, assign it a “D”

So summed up it would be

• >30 k …….”A”
  
• >15k but <30k….”B”
  
• >6k but <14999…..”C”
  
• <5999 …..”D”

Would anyone have any input on how to go about this IF statement,or if perhaps there is an easier function? Thank you!

 

[Joe4]

One way is to use a NESTED IF, i.e.

=IF(A1>30000,"A",IF(A1>15000,"B",IF(A1>6000,"C","D")))

 

[jtakw]

Hi,

Your description has gaps between levels, at exactly 6000, 15000, 30000 has no designation, I've assumed 6000 or higher, 15000 or higher, etc.

Book1
	A	B	C	D	E
1	15000		B	B	B
Sheet287

Cell Formulas
Range	Formula
C1	=IF(A1>=30000,"A",IF(A1>=15000,"B",IF(A1>=6000,"C","D")))
D1	=LOOKUP(A1,{0,6000,15000,30000},{"D","C","B","A"})
E1	=IFERROR(LOOKUP(A1,{0,6000,15000,30000},{"D","C","B","A"}),"D")

Edit: If you might have Negative values in A1, use the alternate LOOKUP formula in E1, otherwise D1 will do.