The basics
Remove a minus sign (absolute value)
=ABS(A2)How it works in Excel
- ABS returns the number without any minus sign.
- This is useful for measuring a gap when direction does not matter.
The idea in general
It measures how far a number is from zero, whichever side it is on.
What I assumed
- The number is in A2.
Check the result on your own data before relying on it.