Hi,

I hope you can be of help.

I require a formula that based on the value of a cell the result returned has multiple possibilities.

If the value is less than £500.00 then *0
If the value is £500.00 to £749.99 then *5
If the value is £750.00 to 999.99 then *7.5
If the value is £1000.00 and upwards then *10

Any help appreciated.