ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / MATH & TRIGONOMETRY

ABS Excel function

Returns the absolute value.

Correct sentence to use

Return the absolute value of [number].

Modify this query in PlainFormula →

Example formula

=ABS(A2)

Returns a number without its sign.

Syntax

ABS(number)

Argument signature: number

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions