Hi There,

In one column I have a range of percentages and I would like to bucket the 20%s as 20%, and if the value is between 30 and 39% bucket it as 30% and so on.
An example of my formula which does not work looks like this.

=IF(AND(V8>=0.2,V8<0.29),"20%",IF(AND(V8>=0.3,V8<0.39),"30%",0))

and my values are in this format 46.4285714285714%.

Any help on this would be greatly appreciated.

Regards
RichG