Hi Guys Thanks for responding sorry I didn't reply sooner I have been out of the country.

I am getting myself a little confused so if I try and type out the formula I am wanting to do maybe someone could help. I apologize but this is new stuff to me really

Basically I have some discount rates if someone buys over a certain number of units they are as follows

1000-10000 no discount
11000-25000 5% discount
26000-50000 10% discount
Over 50000 20%
Over 100000 30%

Basically I have the formula in my head I just can't translate it into an IF especially a nested one.

the formula in my head goes a bit like this

US = Units Sold
SP = Sale Price

IF US is > 100,000 Then do SP/100*30 = Discount Price for 1 unit. If its not then do
IF US is > 50,000 But < 100,000 then do SP/100*20 and so on til I have checked all discount rates.

Is there a better/easier way of doing this?