### 3 Answers

Relevance

- DEBSLv 71 month agoFavourite answer
An 'absolute reference' means that your formula will always refer to a specific cell no matter what.

Relative Reference in C1: =A1+B1

If you were to copy cell C1 to C2, C2's formula would say A2+B2

If you were to copy cell C1 to H19, H19's formula would say F19+G19

Absolute Reference in C1: $A$1+$B$1

No matter where you copy C1 to, that cell will always refer to $A$1+$B$1.

Absolute Reference in C1: $A1+B$1

Copy C1 to H19, H19's formula will be $A19+H$1 (The $ holds the column and/or the row so that it never moves.)

- L.N.Lv 71 month ago
An absolute is a real number magnitude without regard for sign.

- Log in to reply to the answers

- Barkley HoundLv 71 month ago
Absolute means an integer with no sign. abs(-5) = 5

- Log in to reply to the answers

Still have questions? Get answers by asking now.

Thanks DEBS that's very thorough!