How to use ABS function in Excel

This article describes the formula syntax and usage of the ABS function in Microsoft Excel.

PurposeĀ 

Returns the absolute value of a number.

Sample Usage

ABS(-2)

ABS(A2)

Syntax

ABS(value)

  • value – The number of which to return the absolute value.

Examples

A B
1 Result Formula
2 26 =ABS(-26)
3 3.68 =ABS(-3.68)
4 2 =ABS(-6/3)