What does absolute mean?
What does absolute mean in excel? What are absolute excels?
- 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.
- Barkley HoundLv 71 month ago
Absolute means an integer with no sign. abs(-5) = 5