I'm an occasional user of Numbers who's stumped by a simple issue.
I'm doing a spreadsheet that has columns for 'Number', 'Rate', and 'Total' where 'Total' = 'Number' x 'Rate'. I can do a formula for each line where e.g. the function for the 'Total' cell G4 is E4*F4.
But, how do I set up a formula so that each successive G cell in a column is the product of cells E and F on the same row?
Thanks.
I'm doing a spreadsheet that has columns for 'Number', 'Rate', and 'Total' where 'Total' = 'Number' x 'Rate'. I can do a formula for each line where e.g. the function for the 'Total' cell G4 is E4*F4.
But, how do I set up a formula so that each successive G cell in a column is the product of cells E and F on the same row?
Thanks.
iMac 20" Aluminium and Mac Pro 2008, Mac OS X (10.6.1)
The trick is :
(1) create only the useful rows
(2) use the same formula in every cells of a single column.
Asuming that every existing cells of column G contain the formula:
=E*F
when you will add a new row, the formula will be inserted automatically.
If you failed to do that, assuming that row 1 is an header one, insert
=E*F (or =E2*F2) in cell G2 then select the circular handle at the right bottom of the cell and drag it to the bottom of the column.
You will get =E*F in every cells
or
=E3*F3
=E4*F4
=E5*F5
…
The use of the fill down feature is clearly described in *Numbers User Guide*
I'm too busy to search for the description of the auto-insert feature
Yvan KOENIG (VALLAURIS, France) mardi 23 mars 2010 18:58:44
(1) create only the useful rows
(2) use the same formula in every cells of a single column.
Asuming that every existing cells of column G contain the formula:
=E*F
when you will add a new row, the formula will be inserted automatically.
If you failed to do that, assuming that row 1 is an header one, insert
=E*F (or =E2*F2) in cell G2 then select the circular handle at the right bottom of the cell and drag it to the bottom of the column.
You will get =E*F in every cells
or
=E3*F3
=E4*F4
=E5*F5
…
The use of the fill down feature is clearly described in *Numbers User Guide*
I'm too busy to search for the description of the auto-insert feature
Yvan KOENIG (VALLAURIS, France) mardi 23 mars 2010 18:58:44