increase a column value by 20%

Gunther,

In another column, reference the original column and multiply by 1.2

Since you appear to have a number of columns to convert, I would suggest a separate table for the multiplication, but it would be ok to just add columns as needed in the original table. As you may be aware, Excel has a feature that can multiply all values in a column by the same constant without the need for an auxiliary column. Numbers doesn't have that feature, but it's not difficult to duplicate the end result.

If you wish to take one column at a time, you can proceed like this... (after creating a backup file for safety)

If, for example, your $ values are in column A, select a cell in column A and Option-RightArrow. This adds a blank column to the right, with similar formatting. Then in the first body cell of this new column B, enter =A * 1.2 Fill down to the last body cell in the column. Now click the column label of Column B and Command-Click the Header cell (if there is one). This selects all the cells below the header. Next Command-C. Then click (select) the first body cell of column A and Edit > Paste Values. Now you will have replaced all the values in A with 1.2 times the original values.

Repeat for your other fields.

You may find it easier to use an auxiliary table if you have many columns (fields). This approach assumes that you don't have any equations in your original table. Select the entire original table by clicking on the table name in the Sheets Pane. Command-C, Command-V. Now you have a duplicate. Tidy-up the layout and then in the first body cell (A2 I presume) type =TableNameOfFirstTable :: A2 * 1.2 Fill Across and then Fill Down to set the formula in all data cells. Verify the result at then select the entire new table and Command-C. Select A1 in the original table and Edit > Paste Values. You may delete the auxiliary table.

If you have equations in your original table, you will have to step carefully around them.

Jerry

You can make a new column next to the one you want to change, then enter the formula:

=<ORIGINAL CELL>*1.2

B2=A2*1.2

select B2 and fill down

... I got that for the first cell, but how do I duplicate for the other cells in column B?

With the first cell selected (the one with the expression in it), Grab the Fill Handle in the lower right corner of the cell and pull it down the column.

Jerry

Type the formula in the first cell. Select the first cell:

then hover the cursor over the circle at the bottom right of the selected cell. Click, hold, drag down, then release:

Gunther,

Take a look at the Numbers User Guide (download from the Help menu) Chapter 4, Section: Autofilling Table Cells.

Jerry