Hi Paul!

Three possibilities he

If you have a constant range (e.g. 1-10, 11-20, 21-30), you can derive
a formula.

With a limited number of alternatives use the AND function in your
condition for an IF function.

With more than (say) three alternatives, take a look at VLOOKUP.

Which possibility you adopt will depend upon more details as to your
data and the figures you want to show.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia