Formula errors · Short guide

Why does Excel look at the wrong cell when you copy the formula?

Braxorn · Last updated 2026-11-22 · English

Relative references change depending on the position when the formula is copied. If the same tax rate or coefficient will be used in all rows, it is necessary to fix the relevant cell with an absolute reference.

What can you do?

  1. In the formula to be copied, separate the addresses that should change according to the row and those that should remain constant.
  2. Use $ signs for the fixed cell; Note that pinning a single row or a single column is different.
  3. Copy the formula to two rows first and check the new addresses in the formula bar.

A small example

If there is a ratio in cell E1, the formula =B2*$E$1 becomes B2, B3 when copied down; E1 remains constant. If =B2*E1 is written, the second line may look at E2 by mistake.

What to watch for

Fixing every address is also wrong. References that need to change, such as quantity or line-specific price, need to move.

Check the result

Compare the formulas for the first and last row and verify that the common coefficient has not changed.

Examples are synthetic. Formulas use English function names and comma separators; names or separators may differ with your Excel language and regional settings. Menus and features vary by version.

Microsoft source (English)

Microsoft source (English)

Review your own workbook

You can start reviewing your Excel file in Braxorn. Check which controls are supported and review incomplete checks alongside the report scope.

Review your file