Skip to main content
ABS

Returns the absolute value of a number, ignoring its sign (+/-)

Updated over a year ago

Description

The ABS() function computes the absolute value of a given number, eliminating its sign. It's particularly useful for calculating distances, differences, or handling magnitudes irrespective of positive or negative values.

Syntax

ABS(number)

Output

number

Variables

  1. number: The numeric value for which you want to find the absolute value.

Example

ABS(`Price (USD)`)

Product

Price (USD)

Quantity Sold

ABS

Product A

25.99

150.00

25.99

Product B

14.75

280.00

14.75

Product C

7.99

500.00

7.99

Product D

35.50

90.00

35.50

Product E

50.00

120.00

50.0

Did this answer your question?