» Stats
Members: 48,606Rindalik (4,430) Welcome to our newest member, MariaTCTfunds
» Fitness.com Fitness Shop
If you
register for
free , you will be able to post threads, vote on polls and lots more. If you have problems with the registration or logging in, please
contact the administrator.
Disgustingly easy excel question Post #1 Junior Member
Join Date: Jan 1970
Posts: 0
Rep Power:
0
Disgustingly easy excel question
I cant remember how to use excel at all on accounts of never bloody using it since school BUT
so column A is a quantity column B is the cost per I want column C to be the result of A * B?
Disgustingly easy excel question Post #2 Junior Member
Join Date: Jan 1970
Posts: 0
Rep Power:
0
Oh you have about 3 minutes until I leave for work
Disgustingly easy excel question Post #3 Junior Member
Join Date: Jan 1970
Posts: 0
Rep Power:
0
i know the answer! =sum (a*b)
Disgustingly easy excel question Post #4 Member
Join Date: Oct 2005
Posts: 46
Rep Power:
0
=A1*B1 in the cell you want the answer, where A1 and B1 are the cells you're multiplying. Jimbo's way will also work tho I think.
Disgustingly easy excel question Post #5 Junior Member
Join Date: Dec 2004
Posts: 0
Rep Power:
0
Either will work.
Disgustingly easy excel question Post #6 Junior Member
Join Date: Jan 1970
Posts: 0
Rep Power:
0
dont forget to c&p for the other rows :thup:
Disgustingly easy excel question Post #7 Junior Member
Join Date: Dec 2003
Posts: 0
Rep Power:
0
Quote:
Originally posted by Rocky Rockstar:
dragging the lower right corner is more effective- C&P could just end up with the answer in C1 (assuming thats where the answer will be displayed) repeated for each calculation.
Thread Tools Display Modes Linear Mode
Thread Date Forum Replies Last Post laptops 10-13-2007 The Pub 56 10-15-2007 12:33 AM Did anybody else just see Graham Spencer randomly talking about smoothies on BBC1? 09-18-2007 The Pub 30 09-19-2007 05:23 PM Mates, find me a TV please? 09-15-2007 The Pub 28 09-16-2007 11:04 AM Holiday to Barcelona 09-12-2007 The Pub 25 09-12-2007 11:42 PM Disgustingly easy excel question 09-12-2007 The Pub 6 09-12-2007 10:43 AM
Thread Date Thread Starter Replies Last Post Bike riders (crank?) - lights! 11-07-2007 Richie J 3 11-07-2007 04:28 PM 30 reasons why we hate the French 10-17-2007 Meitheisman 51 10-17-2007 02:50 AM Onesies, inspired by Scrubs 10-16-2007 Dotsy 19 10-16-2007 05:19 PM Germaine Greer and Sean Hughes 09-21-2007 James Tringham 13 09-21-2007 05:41 PM The OTF Coupe du Monde de Rugby à XV Thread (inc. warm-up matches) 08-03-2007 The Best In The World (TBITW) 898 09-15-2007 10:54 PM
» Online Users: 26 0 members and 26 guests No Members online Most users ever online was 2,128, 07-21-2008 at 08:27 PM.
All times are GMT +1. The time now is 08:30 PM .
Disgustingly easy excel question 
Linear Mode
