Glad it worked.

Thanks for the feedback.

--
Ian
--
"rpbsr" wrote in message
...
That's perfect Ian. Thanks.

"Ian" wrote:

=IF(B1<=500, 0.2,IF(B1<=1000,0.15,IF(B1<=5000,0.125,0))) and format as
percentage.

I've assumed that anything over the maximum in a range goes into the next
range (eg.$500.01) and that anything over 5000 results in 0.

--
Ian
--
"rpbsr" wrote in message
...
For example:
0-$500 = 20%
501-$1000 = 15%
1001-$5000 = 12.5%

Thank you!