6 Replies Latest reply: Apr 18, 2013 5:25 AM by jaxjason
Ox Level 1 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:

 

Screen Shot 2013-04-17 at 11.35.07 PM.png

 

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.

  • Yellowbox Level 6 Level 6
    expertise.macosx
    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.

    Menu > Insert > Fill.

     

    Regards,

    Ian.

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Ox,

     

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

     

    The Guide is available for download from the Numbers Help Menu.

     

    Regards,

    Ian

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Ox,

     

    multiple cells to use a single cell value to calculate from

     

    Maybe you mean this:

     

    Screen Shot 2013-04-17 at 11.35.07 PM.png

     

    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.

  • Ox Level 1 Level 1

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

  • Yellowbox Level 6 Level 6
    expertise.macosx
    Mac OS X

    Hi Ox,

     

    I misread your question at first, but I finally got there.

     

    Thank for the green tick.

     

    Regards,

    Ian.

  • jaxjason Level 4 Level 4

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

     

    Jason