Absolute Function

The absolute function allows the user to get the absolute value of a cell.

Here is a step by step guide on how to add absolute function to your calculation:

1. Click on ABS button or Type ABS()

2. Input your Calculation instead of the ABS(your calculation)

Example of the same calculation with and without ABS, Profit Ratio is the resulting column.

Absolute

No Absolute