6 Replies Latest reply: Apr 18, 2013 5:25 AM by jaxjason
Level 1

How do I set multiple cells to use a single cell value to calculate from without having to input each formula separately when in a table?

Solved by Yellowbox on Apr 17, 2013 6:39 AM Solved

Hi Ox,

multiple cells to use a single cell value to calculate from

Maybe you mean this:

The single cell value in A2 is fixed for all formulas in Column C. Use the \$ notation (absolute cell reference)

Formula in C2 (and filled down) is =\$A\$2*B2

Row numbers for B change as you fill down. \$A\$2 is constant in all rows of C

Regards,

Ian.

• Level 6
Mac OS X

Hi Ox,

Enter the formula in a cell at the top (or left) of your range of cells.

Press return.

Click once on that cell and you will see a small white circle bottom right of that cell.

Drag the circle down to fill a column, or right to fill a row.

Or,

Click in the first cell, then shift-click to select to the end of the range.

Regards,

Ian.

• Level 6
Mac OS X

Hi Ox,

Page 81 of the Numbers'09 User Guide: Autofilling Table Cells.

Regards,

Ian

• Level 6
Mac OS X

Hi Ox,

multiple cells to use a single cell value to calculate from

Maybe you mean this:

The single cell value in A2 is fixed for all formulas in Column C. Use the \$ notation (absolute cell reference)

Formula in C2 (and filled down) is =\$A\$2*B2

Row numbers for B change as you fill down. \$A\$2 is constant in all rows of C

Regards,

Ian.

• Level 1

Hi Ian, thanks for the help. Your last solution has nailed it.

• Level 6
Mac OS X

Hi Ox,

Thank for the green tick.

Regards,

Ian.

• Level 4

Page 129 in the numbers manual talks about absolute referencing (the \$ in the formula)

Jason