Grouping Percentages

[compd]

Hi Guys,

I am wondering if anyone could assist with finding a formula to group various percentages into the different percentage groups.

For example "Less than 0%", 0-5%,5-10% and, "More than 15%"

Thanks

 

[Jon von der Heyden]

Welcome!

You can use various lookup functions, and you can reference ranges or inline array constants. For example:

=LOOKUP(A1,{-9.999E+307;0;0.05;0.1;0.15},{"less than 0%";"0-5%";"5-10%";"10-15%";"15% +"})

If you choose VLOOKUP or HLOOKUP make sure you use approximate match type (final argument = TRUE).

 

[compd]

Perfect, Thank you.