In numbers '09, I have 24 numbers and want to add 89 to each, with 24 distinct results. How?

HI t,

Assuming the numbers are in column A, starting at A2, and that you want the results in column B, and in the same row as the original numbers:

B2: =A2+89

Fill down for 24 rows to B25.

To fill down:

After entering and confirming the formula in B2,

Select cell B2.

Shift-click on cell B25 to add it and all cels between it and B2 to the selection.

Go Insert (menu) > Fill > Fill Down.

Done.

Regards,

Barry

Chamo,

First, make sure your first numeric entry and your first expression are both in the first Body Row, and not in a Header Row.

Then, Select the cell with the expression. In Numbers '09 a little open circle will appear in the lower right corner of that selected formula cell. Drag that corner with the circle down until you have reached the last row with data.

Jerry

If you're having trouble with the Insert menu options, you can try clicking once on the cell with the formula and dragging the dot that appears on the lower right corner of the cell down the column.

SG