Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using Google Docs / Exel and can't work out how or where to add a 'formula'.

I have a column "i" which is the number of items. I have another column "j" which is the cost of those items. Column "i" has various number of items and column "j" has varying prices.

So, in short I want column "k" to be the total of column "i" x column "j".

Any help in how / where to insert this formula is much appreciated.

Thank you

share|improve this question
add comment

1 Answer 1

To add a formula to a cell, you put an equal sign (=) and then the formula. So, the formula for cell I1 times J1 would be:

=I1*J1

and would look like this:

an example formula

You could then copy-paste or fill-down this formula for as many rows of data as you have.

Edit: To fill-down a formula, drag the black box on the bottom-right corner down through your rows of data, like this:

fill down explanation

This copies the formula into each cell, replacing the row references with the appropriate row (row 2, row 3, etc.).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.