New: ready-to-use spreadsheet templatesExplore the collection  →
Google Sheets · Verified tutorial

Macro not running in Google Sheets

The macro did not populate the Adjusted amount column. In C2 enter exactly =B2*1.1, then fill that formula down through C4.

Verified by JosephineAbout 75 seconds
Quick answer

The macro did not populate the Adjusted amount column. In C2 enter exactly =B2*1.1, then fill that formula down through C4.

Step-by-step

1

Select the targetThe macro did not populate the Adjusted amount column.

2

Complete the next actionIn C2 enter exactly =B2*1.1.

3

Apply the changefill that formula down through C4.

Shortcut or faster method

Select the target cell, type or paste the formula in the formula bar, then press Enter.

Expected result

C2:C4 contains the adjusted amounts 88, 132, and 330.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Re-select C2 and repeat the final action. C2:C4 contains the adjusted amounts 88, 132, and 330.

Example spreadsheet data

This is the clean fixture used for the verified run.

ItemAmountAdjusted amount
Hosting80
Software120
Design300

Video transcript

  1. Open the prepared Macro fallback spreadsheet.
  2. Select the target. The macro did not populate the Adjusted amount column.
  3. Complete the next action. In C2 enter exactly =B2*1.1.
  4. Apply the change. fill that formula down through C4.
  5. C2:C4 contains the adjusted amounts 88, 132, and 330.