N
Norman Harker
Hi Keevil!
With your table of rates in (e.g) H1:I4:
1 50
10 55
25 62
30 67
Try:
=VLOOKUP(A1,$H$1:$I$4,2)
Returns the appropriate rate for the quantity in A1 from the second
column of the table.
If the table is on another sheet, you need to name it:
=VLOOKUP(A1,MyRates,2)
You also need to be a bit more disciplined with your borders between
rates. (i.e. you give 55 and 62 for 25 pages)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
With your table of rates in (e.g) H1:I4:
1 50
10 55
25 62
30 67
Try:
=VLOOKUP(A1,$H$1:$I$4,2)
Returns the appropriate rate for the quantity in A1 from the second
column of the table.
If the table is on another sheet, you need to name it:
=VLOOKUP(A1,MyRates,2)
You also need to be a bit more disciplined with your borders between
rates. (i.e. you give 55 and 62 for 25 pages)
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.