ABS function

The Klipfolio ABS function calculates the absolute value of all non-blank values in a range of data.

The syntax for the ABS function is:

ABS (data )

ABS example

Let's look at an ABS function example.

 

A

1 -100

The following example is based on the above text from an Excel spreadsheet:

ABS( A1 ) 

-> [100]

Related links: