ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   DProduct question (https://www.excelbanter.com/excel-worksheet-functions/268081-dproduct-question.html)

ModernBeat

DProduct question
 
Hey guys, apologies for being one of the, it appears, hundreds of people that come here to have you guys solve an excel related issue that may be run into and thanks in advance for your assistance.

What I'm looking for is a way to automatically give me a the product of two numbers for the purposes of inventory keeping.

Column A will be number of items in the store and Column B is the price of said item. A x B = Column C. I'm looking at hundreds of items of merchandise and to repetitiously insert the very simple forumula "=Product(Ax, Bx)" into Column C could take me weeks. Is there any way to format a certain number of cells to produce these results for me?

Again, thank you very much for your input guys/girls.

ModernBeat

Is this at all possible? I have a vague memory of doing this before but unfortunately my boss is running on excel 03, so I don't really know if this is possible.


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com