Hi Richard

Whether your price break data is horizontal or vertical, in needs to be
in 2 distinct rows or columns.
You cannot have it all in the same row.

if you had in C1 1, D1 20, E1 100
and in C2 ?73.75, ?69.95 , ? 65.00
Then with Qty entered in A3
in A4
=HLOOKUP(A3,$C$1;$E$2,2,0)

--
Regards

Roger Govier


"Richard Sheoo" wrote in message
...
Hi Duke,

Still struggling. This calc has to be performed horizontally because
there
are multiple lines and prices

Tot QTY Tot Val Price break 1st price Price Break
2nd
price
0 #N/A 1 ?73.75 20 ?69.95

I thought I was pretty useful in excel until this. Have you got any
ideas?

Kind regards

Richard


"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