Excel’s ABS() function is another super-simple Excel function.

In this tutorial:
  1. Syntax
  2. Example
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.

Using Excel's ABS() function.Using Excel's ABS() function.

References:

  1. 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).

By MisterFoxOnline

Mister Fox AKA @MisterFoxOnline is an ICT, IT and CAT Teacher who has just finished training as a Young Engineers instructor. He has a passion for technology and loves to find solutions to problems using the skills he has learned in the course of his IT career.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.