Ok, i admit it, I need your help :)
In essence I have a range of varying values from 72.73% to 120% etc, I’m looking to set ranges that I can then just filter by, such as 0%, 25%, 50%, 75% 100% and 100+
=IF(AND(W2>=0.1,W2<=24.99),”25″,IF(AND(W2>=25,W2<=49.99),”50″, IF(AND(W2>=50,W2<=74.99),”75″, IF(AND(W2>=75,W2<=99.99),”100″,””))))