cairnterrier wrote:
Okay, be gentle. Am feeling very fragile and very fed up of this now. It's teddies out of the pram time.
Love the metaphor!
Here are two ways to accomplish this:
1.
Enter the formula in G10.
Click on G10 to (re)select it.
Grab the control (small circle at the bottom right of the selection border) and drag it down as many rows as you wish to have the formula. Numbers will adjust the cell reference to fit.
2.
Enter the formula in G10.
Select G10 and all of the cells below in which you wish to use the formula.
Go to the Insert menu and choose Fill > Fill Down.
You could also replace your formula with this version, using the multiplication operator:
=F*0.20
Numbers interprets cell references using only the column letter as meaning either the cell in that column on the same row as the cell containing the formula, OR the range of all cells in that column, depending which interpretation is appropriate to the formula.
Regards,
Barry
PS: An excellent place to have started your search would have been Chapter 4, Working with Table Cells, in the Numbers '09 User Guide. The Table of contents would lead you to the article "Autofilling Table Cells" on page 78.
You can download the Numbers '09 User Guide (and the iWork Formulas and Functions User Guide—a reference for all of the functions supported by Numbers, with syntax and descriptions) through the Help menu in Numbers.
B