Add 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”