Copying formulas and locking references

Was du danach kannst

Copy a formula down a column, predict what happens to its references, and use $ to hold one of them still.

You wrote the line total once. Now it needs to be on all twelve rows, and the branch manager wants a tax-inclusive column that uses one rate stored in one place. This is where most people's first spreadsheet quietly breaks.

Schritt 1 von 6 · 1 Punkt

G2 holds =E2*F2. Copy it down to G13 so every order has a line total.