An 'If' formula is how you can set predictions based on unknown future circumstances.
In the example below, the formula is going to calculate 20% commission if Income is greater than or equal to £50,000. However, it will calculate 10% if it's less than £50,000.
📎NOTE: The screenshot below is for comparison purposes only. The first line will replace the second line.
The condition is @Income
The variable replaces the equals - in this case, greater than or equal to
True for this example is £50,000
Option A is the variable if the condition is hit, so: Income multiplied by 0.2 to give 20% of the total of Income
Option B is if the condition isn't hit, so 'Income' multiplied by 0.1 to give 10% of the total of 'Income'
📌TIP: Click the ❔in the formula builder for further tips and guidance on building a formula.
