Filtering Dimensions By Range in Bar Graph

[az1234]

I am trying to filer a graph to show my data in ranges. i.e. how many scounts fall within a range between 0-25% and so on. This is the formula I have now. Any help would be greatly appreciated. Thanks!

IF(formula])>=0<0.25,('0-25%')
IF([formula])>=0.26<0.50,'26%-50%')
IF(formula])>=0.51<0.75,'51%-75%')
IF([formula])>=0.76<1,'76%-100%')))))

[Lisa_P]

Try this:
=IF(formula>=0 and Discount <0.25,'0-25%',
IF(formula>=0.26 and Discount<0.50,'26%-50%',
IF(formula>=0.51 and Discount<0.75,'51%-75%',
IF(formula>=0.76 and Discount<1,'76%-100%'))))

or use the Class function:
class(field, 0.25)