Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up product pricing calculator?
I have list of products that i want calculating on Ecel. Could you show me
how to set it up on excel. Product 1 - 12.50 x 2 quantity product 2 - 2.99 x 3 quantity product 3 - 3.50 x 1 quantity Total I want the total price to change whenever i add or subtract the quantity of each item. Please advise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up product pricing calculator?
You just multiply. If your product price is in a1, and your quantity is in
a2, then your formula is: =a1*a2 Regards, Fred. "theperson1" wrote in message ... I have list of products that i want calculating on Ecel. Could you show me how to set it up on excel. Product 1 - 12.50 x 2 quantity product 2 - 2.99 x 3 quantity product 3 - 3.50 x 1 quantity Total I want the total price to change whenever i add or subtract the quantity of each item. Please advise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More lines in Product Pricing Calculator | New Users to Excel | |||
create a product calculator | New Users to Excel | |||
Old to New Pricing | Excel Worksheet Functions | |||
Excel vs. calculator multiplication product discrepancy... | Excel Worksheet Functions | |||
Pulling product pricing from worksheet into proposal template | Excel Discussion (Misc queries) |