Please can any one help me?

I need to be able to work out a total price but the price will change as the
quantity increases.

For example 1 @ £1.99 5 @ £1.85 10 @ £1.75

Our customers may order say 6 units How do I tell excel to calulate this
properly?

Kind regards
Richard