I'm trying to set up a formula to calculate commissions based on weekly
sales, as follows:

If $1000<sales<$2500, commission = sales*30%
If $2500<sales<$4000, commission = sales*35%
If $4000<sales<$4500, commission = sales*40%

Can anyone help, please? I'm using Excel 2000.

Thanks.