Formulas
Thanks Jeff
"jeffbert" wrote:
First, you have to set up a table with the fluctuating costs.
Qty Cost
1 1.99
5 1.85
10 1.75
Then, use the vlookup function but make sure set the last argument of the
function to "TRUE". If 4 units are ordered, the vlookup will return 1.99, if
5 are ordered, it will return 1.85.
Jeff
"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
|