Excel ABS Function

Use:

Computes absolute value of a single cell or numeric formula

Syntax:

ABS( cell )

Examples:

Cell E3 formula:     ABS( D3 )

Alternative E3 formula:     ABS( B3 + C3 )
Cell B7 formula:     ABS( SUM( B3:B6 ) )

Note:

ABS( cell ) is equivalent to IF( cell>=0 , cell , -cell )

Related Functions:

IF, MIN, MAX