Hi,

I've tried to search to find an answer to this question, but I've
drawn a blank so far. If I've got a column which displays salary
details, is there any easy way to "band" the results into user-defined
ranges (i.e. $0-$5000, $5000-$10000 etc.). Thus far I've been using a
long-winded IF statement, but I'm hampered by the amount of nested IFs
I can use - for the latest spreadsheet I'd need more than 20 IFs to
split the results into the relevant bands.

I can't help thinking there must be an easier way of doing this. Can
anyone help?

BH