5 Replies Latest reply: Mar 3, 2010 10:09 AM by KOENIG Yvan
Level 1
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?

#### All replies

• Level 6
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
• Level 1
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)??
• Level 1
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.
• Level 6
=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.
• Level 8
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