Posts by vokivoki

Here is the product list that I wish to be in pulldown menu:
Valve 1 - 1/2”
Valve 1 - 3/8”
Valve 1 - M20 x 1,5
Valve 1 - M18 x 1,5
Valve 2 - 1/2”
Valve 2 - 3/8”
Valve 2 - M20 x 1,5
Valve 2 - M18 x 1,5
Valve 2 - 3/4"

Here is the pricing (same price for both product 1 and product 2):
Price 1 - €1.35 [quantity 1-999 units)
Price 2 - €1.35 - 25% [quantity 1,000-4,999 units)
Price 3 - €1.35 - 27.5% [quantity 5,000-9,999 units)
Price 4 - €1.35 - 30% [quantity 10,000+ units)

Also
this order of cells is not an imperative

product 1 | quantity | price1 | subtotal

whatever is the easiest way to accomplish this mathematically

Your help is greatly appreciated.

Voki:spin:

thans for the tips guys.

here is more specifics:

cell 1 should contain full product names
product1
product2
...

cell 2 next to it should contain quantity that will determine the pricing (appropriate rebate based on quantity)
price1 if 1-100 units
price2 if 200-300 units
etc for 3 price levels

cell 3 should keep a subtotal for that line

product 1 | quantity | price1 | subtotal

as far as the listing of products goes i can easily put it on the worksheet in the same file as there are only about a dozen products. i am more puzzled how to do an IF this quantity THEN this price part of the formula (if that is the appropriate way to go about this).

the rest I can figure our by taking a sum of vertical lines

thanks for your help

voki

Hi guys and gals,

I need help creating complex invoice that will contain menus with product names and be tied with the specific pricing for appropriate quantities.

In essence I wold like to open spreadsheet, select a product from a lulldown list, and enter quantity of the item bought and for the formula to get the price for that quantity and total it at the bottom. (there would have to be 4 different tiers of prices).

I know basic programming but am at a loss how to start on this one. Any help or tips would be gratly appreciated. If there is a specific section in the excel help files that deals with this topic please let me know which one it is so i can look it up.

Many thanks folks
voki