Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: How can I create a formula on numbers to divide a column and make the answer appear in another column?

How can I create a formula on numbers to divide a column and make the answer appear in another column?

Posted on

Reply

Page content loaded

Mar 9, 2018 10:53 AM in response to taiya258 In response to taiya258

Create the formula in the cell where you want the answer to appear: =(cell1/cell2).


Please learn to post in the proper forum. Your topic does not belong in this forum. I have asked the moderators to move it to a correct forum. Please read Writing an effective Apple Support Communities question and Apple Support Communities - Terms of Use.

Mar 9, 2018 10:53 AM

Reply Helpful

Mar 9, 2018 11:41 AM in response to taiya258 In response to taiya258

Hi Taiya,


Here's a picture:

User uploaded file

The formula is shown below the table as it appears in the formula editor.


To enter the formula:

  • Click on the result cell (D2)
  • type = to open the formula editor.
  • Click on cell B2
  • type / (Numbers will immediately change that to the division sign, ÷ )
  • Click on cell C2
  • Click the green checkmark to confirm the entry.


To fill the formula down the rest of the column:

User uploaded file

  • Move the mouse pointer close to the bottom of cell D2. A Fill Handle (yellow circle) will appear.
  • Grab the fill handle with the pointer and drag down to copy the formula into the rest of the cells in column D.
    • If cells in column C are empty, this will produce error triangles in column D due to a
      division by zero error.
    • If the cells in columns B and C already contain data, the cells in column D will show the results of the division.


Regards,

Barry

Mar 9, 2018 11:41 AM

Reply Helpful
User profile for user: taiya258

Question: How can I create a formula on numbers to divide a column and make the answer appear in another column?