How do you make a column use division in an equation?

Question

Level 1

0 points

How do you make a column use division in an equation?

Please help! If I have 10 numerical entries running down in column A and I want to divide each of these by the number 11, how do I do this? I want each of these answers (division by 11) to appear in column B. I then want each entry from column A to subtract these new "divided by 11 answers" from column B and these new answers to appear in column C. When I try to create an equation it just won't calculate!! (it usually just lists the equation exactly as I typed it (eg. A/11) What part / column do I need to highlight, how and where do I type the equation and how can I get my answers to appear in the above locations?

Posted on Mar 1, 2010 2:56 AM

Reply

Answer 1

Best reply

Badunit

Level 7

25,664 points

Mar 1, 2010 4:53 AM in response to Frosty Noir

Frosty Noir wrote:
When I try to create an equation it just won't calculate!! (it usually just lists the equation exactly as I typed it (eg. A/11) What part / column do I need to highlight, how and where do I type the equation and how can I get my answers to appear in the above locations?

Put an = in front of the formula. Otherwise it is treated as text, not a formula.

=A/11

Reply

Answer 2

Frosty Noir Author

Level 1

0 points

Mar 2, 2010 1:39 AM in response to Badunit

Thank you! That equation seems to give me one total figure for the whole column. Do you know how to get individual answers for each entry in column A (ultimately to list the answers in each adjacent cell in column B)??

Reply

Answer 3

Mar 2, 2010 3:04 AM in response to Frosty Noir

Select the first cell where you wrote the equation(=A/11) and then press and hold the small circle from the right lower corner of the cell, and then drag downward to the other cells in the column B and the results will be listed.

Reply

Answer 4

Badunit

Level 7

25,664 points

Mar 2, 2010 5:33 AM in response to Frosty Noir

=A/11 does not give you "the total figure for the whole column" divided by 11. If you put this formula in a cell in cell B2, it is the same as =A2/11. In cell B3 it is the same as A3/11. Etc.

If the formula is expecting a range it uses "A" as the entire column. If it is expecting a single cell, it uses A as described above. It is pretty handy this way.

Reply

Answer 5

KOENIG Yvan

Level 8

41,807 points

Mar 3, 2010 10:09 AM in response to Badunit

If I understand well, I guess that the OP inserts the formula ( _*not an equation*_ ) in a cell of a footer row.

Yvan KOENIG (VALLAURIS, France) mercredi 3 mars 2010 19:09:55

Reply