How do I find the absolute value of a number?

Using an If/Else Column Step

Use this step to populate a new column with the absolute values of another.

First, create the new step:

Add an If/Else Column step

Select a name for your new column

Next, add values for the case when the value is above zero:

Under “If this is true” select your input column and “is greater than or equal to”

enter 0 in the Condition box

Under “Then set the value to”, put {input column name}

Next, add values for negative values:

Click ”+ Add a rule”

Under “else, if this is true” select your input column and “Is less than” Enter 0 in the condition box

Enter 0 in the condition box

Underneath “then set the value to”, click the gear icon

Make sure the “Accepts math functions” checkbox is checked

Under “Then set the value to”, put {input column name} * -1

A simpler solution can be to use Find and Replace to treat the number as a string and replace the negative sign (-) with nothing.

Add a Find and Replace step.

Select the column with the negative values.

Set it to find “-” and replace with nothing. Make sure you’re searching for “in any part of a cell” and replacing “in any part of the cell”.

Last modified on February 24, 2026

⌘I