GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   Quick Microsoft Excel Question (https://gfy.com/showthread.php?t=549869)

mkx 12-08-2005 08:03 PM

Quick Microsoft Excel Question
 
Column B contains the quantity (ex. 2) and column C contains the price (ex. 5.50), how do I automatically or manually have excel calculate the total cost (column B x column C) and possibly even put it in column D for me. There are to many cells to do this with a calculator.

Right now it is just adding column B + C, example sum = 7.50

Trixxxia 12-08-2005 08:05 PM

Is it B+C or BxC?

mkx 12-08-2005 08:06 PM

Right now by default it is B+C, i need to make it BxC, i think it is something simple but I hardly ever use excel so I am not sure

Trixxxia 12-08-2005 08:07 PM

If it's B+C= D In column D put '=SUM(B1:C1)'
If it's BxC= D In column D put "=SUM(B1*C1)'
Then copy your D1 cell and paste it all the way down.

mkx 12-08-2005 08:10 PM

Thanks so much, that worked!

Trixxxia 12-08-2005 08:12 PM

Coolio :) *It better have, I'm an Excel freak* heheheh


All times are GMT -7. The time now is 04:19 PM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123