|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
12-08-2005, 08:03 PM
|
#1 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
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 |
|
|
|
12-08-2005, 08:05 PM
|
#2 |
|
Confirmed User
Industry Role:
Join Date: Aug 2004
Location: Montreal, Canada
Posts: 5,600
|
Is it B+C or BxC?
|
|
|
|
|
12-08-2005, 08:06 PM
|
#3 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
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
|
|
|
|
|
12-08-2005, 08:07 PM
|
#4 |
|
Confirmed User
Industry Role:
Join Date: Aug 2004
Location: Montreal, Canada
Posts: 5,600
|
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. |
|
|
|
|
12-08-2005, 08:10 PM
|
#5 |
|
Confirmed User
Industry Role:
Join Date: Nov 2003
Location: Toronto
Posts: 4,001
|
Thanks so much, that worked!
|
|
|
|
|
12-08-2005, 08:12 PM
|
#6 |
|
Confirmed User
Industry Role:
Join Date: Aug 2004
Location: Montreal, Canada
Posts: 5,600
|
Coolio
 *It better have, I'm an Excel freak* heheheh |
|
|
|
