8 Replies Latest reply: Mar 23, 2010 12:18 PM by esmonde
Level 1
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.

iMac 20" Aluminium and Mac Pro 2008, Mac OS X (10.6.1)
Solved by KOENIG Yvan on Mar 23, 2010 10:58 AM Solved
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
• Level 8
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
• Level 1
Thank you very much Yvan.

That worked fine when I dragged the circle at the 'Total' cell.

I'm afraid that I could not find the information by searching through the 'Numbers Help File', and unfortunately I'm so unfamiliar with spreadsheets in general that even selecting the correct wording for my query is not always obvious to me. I've only now grasped that what I'm dragging into the adjacent cells in a column is, not the number in the first cell, but the formula that created the number.

I have one further question though. I'm trying to sequentially number a column of cells 1,2,3,4 etc. in Numbers. In 'Pages' I know that I just number the first two as 1,2 and then drag the circle down the complete column of a table and it numbers the column of cells sequentially. But that does not work in 'Numbers'. Any idea how I might do that?

Thanks.

Message was edited by: esmonde
• Level 8

Numbers User Guide
and
iWork Formulas and Functions User Guide

Both of them are PDFs files in which search is an easy task.

Yvan KOENIG (VALLAURIS, France) mardi 23 mars 2010 19:20:12
• Level 1
Thanks again Yvan.

I realised you were speaking about the 'guide', and I had not realised it was accessible when I did my initial search. I've since tried it for my second query and can't find the answer. I would not have found the first answer either because I do not fully grasp the concepts in spreadsheets yet.

While I really do appreciate your help and your pointers for sources of further information, I hope you will realise that sometimes being able to ask the correct question is critical when searching for information.

Regards.
• Level 7
esmonde wrote:
I'm afraid that I could not find the information by searching through the 'Numbers Help File'

esmonde,

The Numbers User Guide, mentioned by Yvan, is not difficult to read cover to cover and it will familiarize you with the terminology.

Jerry
• Level 1
Thanks Jerry.

However, sometimes I'm up against the clock trying to solve a problem, and in desperation I reach out to these fora. And almost always I find helpful people like Yvan and yourself willing to contribute your expertise.

Consider me suitably chastened.

Regards
• Level 7
esmonde wrote:
Consider me suitably chastened.

Not at all. I think many users may be intimidated and just need some encouragement to crack the manual. It's not like reading a dictionary; it can actually be rather interesting.