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%+")))))))))))))))
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%+")))))))))))))))