Transforming data

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” 

Check your work

Image 1 Image 2

Next lesson