Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default 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
Search this Thread:

Advanced Search
Display Modes

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
More lines in Product Pricing Calculator babakatica New Users to Excel 1 September 12th 06 04:24 PM
create a product calculator exceloldiebutnewbie New Users to Excel 1 March 14th 06 05:43 AM
Old to New Pricing Jennings Excel Worksheet Functions 6 February 12th 06 10:41 PM
Excel vs. calculator multiplication product discrepancy... Jray Excel Worksheet Functions 3 October 5th 05 10:40 PM
Pulling product pricing from worksheet into proposal template Bob Excel Discussion (Misc queries) 3 June 15th 05 06:06 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"