This week, we will start digging into formula building allowing you to perform more complex calculations.

We will cover:

  • Using an IF statement to check if a value meets a particular criterion or not and output a specific value if it does and another if it doesn’t
  • Building a ‘Nested’ IF formula, allowing you to test multiple criteria, not just one
  • Creating Calculated Criteria using an IF formula, which is a great way to find results that match ‘this’ OR ‘that
Do you like this post? Why not share it!