Excel’s ABS() function is another super-simple Excel function.
Required knowledge:
1. Syntax
=ABS(number)
Returns the absolute value of a number. The absolute value of a number is the number without its sign.
2. Example
The example below illustrates the use of the ABS() function.


References:
- Microsoft Support. (no date) ABS function. Available at: https://support.microsoft.com/en-us/office/abs-function-ecd891be-d7b3-4bb4-9b59-f72db589cc0d (Accessed: 16 May 2024).