See this site:

http://www.mcgimpsey.com/excel/variablerate.html

for details of how to implement sliding-scale commission.

Hope this helps.

Pete

"cmac" wrote in message
...
Sorry it wasn't very clear. in my explanation. It is a sales commission
multiplier.

If the deal is of a certain size, then an extra bonus is paid.

The levels are as follows:
0 - 50 no calculation
51 - 150 multiply the commission by 10%
151 - 250 multiply the commission by 15%
250 multiply the commision by 25%

I hope this makes it more clear.

"Sandy Mann" wrote:

You don't say what you want to do is the number is smaller than A or
exactly
A, B, C or D so adjust as required:

=IF(A1="","",IF(A110,C4,IF(A1=7,C3,IF(A1=5,C2,C 1))))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"cmac" wrote in message
...
I need to make a table that evaluates a number.

If a number (x) is between (A) and (B), then I have to do a calculation
(C1)
If a number is between (B) and (C), then I have to do a calculation
(C2)
If a number is between C and D, then I have to do a calculation (C3)
If a number is greater than D, then I have to do calculation (C4)

I just can't seem to get the calculations to come out correct.