Posted to microsoft.public.excel.worksheet.functions

billburr

Posts: n/a

tier pricing

Using Excel, I want to look up a garmetn name in column A, then return a cost
per product from column B, C, or D, based on tier quantities purchased.
Example: In one cell(A1) I know the garment , in another cell (A2) I know
the quantity purchased.

Garment 1-23 24-49 50-100
Shirt $5 $4 $3
Pant $10 $9 $8

What formula looks up the garment shirt or pant, then returns price per item
based on second value(quantity)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel User Conference - Few hours left - Early Bird pricing	Damon Longworth	Excel Discussion (Misc queries)	0	February 15th 06 09:22 PM
Excel User Conference - Last day - Early Bird pricing	Damon Longworth	Excel Discussion (Misc queries)	0	February 15th 06 01:02 PM
How do I create a 26 'tier' IF formula?	callum	Excel Discussion (Misc queries)	5	October 23rd 05 04:48 PM
Volume and pricing calculations	Karen	Excel Worksheet Functions	1	May 31st 05 11:52 PM
Formula to extract pricing from a chart	John F	Excel Worksheet Functions	2	November 12th 04 02:04 PM

All times are GMT +1. The time now is 11:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us