Transforming data

Adding an if/else column

While if statements can get quite complex and messy in spreadsheets, Parabola makes it really outline the logic involved in your if/else statements. 

Building challenge

  • To the card titled “Calculate revenue by row and assign statuses”, drop an Add if/else column step on the card.
  • Create an Order Value column with the following statuses:
    • If Revenue is greater than or equal to 100, set the value to “High” 
    • If Revenue is between 50 and 99, set the value to “Medium” 
    • Else, set the value to “Low” 

Check your work

Image 1 Image 2

Next lesson

Using the If/Else Step in Parabola

One of the most powerful steps in Parabola is the If/Else step, which allows you to translate complex logic from Excel formulas or process documentation into an easy-to-read workflow.

How the If/Else Step Works

When you add the If/Else step to the canvas, you can:
Create a new column based on conditions
Update an existing column with new values
Apply multiple rules for precise filtering and categorization

Example: Categorizing Order Value

Let’s say we want to categorize order values based on revenue:

  • High if revenue is ≥ $100
  • Medium if revenue is between $50 and $99
  • Low if revenue is less than $50

Setting this up in If/Else:

  1. Create a new column called Order Value
  2. Define the rules:
    • If {Revenue} ≥ 100, set value to "High"
    • If {Revenue} is between 50 and 99, set value to "Medium"
    • Else, set value to "Low"

Once applied, the results instantly update, showing the categorized order values on the right-hand side.

Advanced Customization

The If/Else step provides additional flexibility:

  • Use multiple conditions (e.g., Revenue must be ≥ 100 AND SKU is not blank)
  • Apply math formulas (e.g., {X} + {Y} > 100)
  • Make comparisons case-sensitive for text-based conditions

Speed Up with AI Configuration

Instead of manually setting up rules, you can:

  1. Paste logic from process documentation directly into the Configure with AI field.
  2. Let AI generate the rules automatically.

Try It Yourself!

Now, test the If/Else step in the building challenge below. Let us know if you have any questions! 🚀