5 Replies Latest reply: Mar 3, 2010 10:09 AM by KOENIG Yvan
Frosty Noir Level 1 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?
Reply by Badunit on Mar 1, 2010 4:53 AM Helpful
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

All replies

  • Badunit Level 6 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
  • Frosty Noir Level 1 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)??
  • Alex Jalba Level 1 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.
  • Badunit Level 6 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 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