Disgustingly easy excel question

retired_mountainsong · 09-12-2007, 08:53 AM

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?

retired_mountainsong · 09-12-2007, 08:53 AM

Oh you have about 3 minutes until I leave for work

retired_dreamwolf · 09-12-2007, 08:54 AM

i know the answer! =sum (a*b)

or something

retired_eddyloin · 09-12-2007, 09:00 AM

=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.

retired_ashlia80 · 09-12-2007, 10:01 AM

Either will work.

I'm disgusted with how easy that was.

retired_linton_justin · 09-12-2007, 10:06 AM

dont forget to c&p for the other rows :thup:

2boxers · 09-12-2007, 10:43 AM

Quote:

Originally posted by Rocky Rockstar:
dont forget to c&p for the other rows :thup:

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.

Disgustingly easy excel question

Grab a beer, sit back and relax.

Disgustingly easy excel question