Formulas
Thanks Duke
"Duke Carey" wrote:
So, if they order 6 do they get the 5 unit price for each of the 6?
If so, then A1:B3 contains
1 1.99
5 1.85
10 1.75
the quantity sold goes in A5, and the total price in B5 with this formula:
=a5*vlookup(A5,$a$1:$b$3,2)
"Richard Sheoo" wrote:
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
|