Help tightening up a formula

[Obied70]

Hey All,
This formula is really simple but way too long. There must be a way to make it shorter but I'm not smart enough to do it. Any help would be great!

=IF(ISBLANK(I2),"BLANK",IF(I2<=-0.3,"(30%)+",IF(AND(I2>=-0.25,I2<=-0.3),"(30%)-(25%)",IF(AND(I2>=-0.25,I2<=-0.2),"(25%)-(20%)",IF(AND(I2>=-0.2,I2<=-0.15),"(20%)-(15%)",IF(AND(I2>=-0.15,I2<=-0.1),"(15%)-(10%)",IF(AND(I2>=-0.1,I2<=-0.05),"(10%)-(5%)",IF(AND(I2>=-0.05,I2<=0),"(5%)-0%",IF(AND(I2>=0,I2<=0.05),"0%-5%",IF(AND(I2>=0.05,I2<=0.1),"5%-10%",IF(AND(I2>=0.1,I2<=0.15),"10%-15%",IF(AND(I2>=0.15,I2<=0.2),"15%-20%",IF(AND(I2>=0.2,I2<=0.25),"20%-25%",IF(AND(I2>=0.25,I2<=0.3),"25%-30%",IF(I2>0.3,"30%+")))))))))))))))

 

[Obied70]

Also I do realize that for this to be correct mathematically, not all of the logic statements should be <= or >= but boss says leave it so it's staying. I'll explain to him the pitfalls of this reasoning when we review again.

 

[Scott Huish]

Have a look at the VLOOKUP function: https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1

I didn't do your whole table, but you can extend it down and adjust the formula to include the entire range:

Excel 2010
	H	I	J	K	L
1
2	(10%)-(5%)	-0.06		-1.00E+308	(30%)
3				-0.3	(30%)-(25%)
4				-0.25	(25%)-(20%)
5				-0.2	(20%)-(15%)
6				-0.15	(15%)-(10%)"
7				-0.1	(10%)-(5%)
8				-0.05	(5%)-0%
9				0%	0%-5%
Sheet1

Cell Formulas
Range	Formula
H2	=IF(I2="","",VLOOKUP(I2,$K$2:$L$9,2,1))

 

[Fluff]

This looks to be the wrong way round to me
AND(I2>=-0.25,I2<=-0.3),"(30%)-(25%)"

If it is you can try writing it like
IF(ISBLANK(I2),"BLANK",IF(I2<=-0.3,"(30%)+",IF(I2<=-0.25,"(30%)-(25%)",IF(I2<=-0.2,"(25%)-(20%)",IF(I2<=-0.15,"(20%)-(15%)",IF(I2<=-0.1,"(15%)-(10%)",

 

[Obied70]

Thanks for the two options! I hadn't even considered using vlookup.