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