Assuming that you mean that if the commission is a figure in say B1 and if
the deal is over 50 then add another 10% to the commission etc. then try:

=IF(A1="","",IF(A1250,B1*1.25,IF(A1150,B1*1.15,I F(A150,B1*1.1,B1))))

or:

=IF(A1="","",B1*LOOKUP(A1,{0,51,151,251},{1,1.1,1. 15,1.25}))

--
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
...
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.