πŸ”₯ 0

BasicsFixed references with $

When you copy a formula, every reference moves. Sometimes one must stay put, like a single tax rate for all rows. A $ fixes it: $B$1 always means B1. On a keyboard, press F4 right after a reference to add the $ signs.

How much tax is due on each item? The tax rate is in B1.

A
B
C
1
Tax rate
19%
2
3
Item
Price
Tax
4
Pen
2
5
Pad
5
6
Ink
10
7
Tape
3
8