IF Statement That Returns YES or NO
A guide on how to create an IF statement that returns "Yes" or "No."
IF statements allow the formulas to make logical comparisons between a value and an expected outcome. In some cases, you can get a better overview of your progress by seeing a simple answer, for example, if your team has reached a target or not. This guide will help you to create an IF statement that returns a "YES" or "NO," depending on the employee performance compared to the target.
An example of a table that returns an IF statement in the column "Target Reached."
To create an IF statement with text, you can use a formula template like the following:
( IF(Sum(<data_source>,<filters>,Field)>Target,"Yes","No") )
Let's say there is a data source called "Deals," containing a field called "Value." We want to see the total value of won deals for each employee and understand if they have reached their targets. In this case, assuming that all employees have the same targets, we can use a static number, for example, 50.000.
An example of a data source called "Deals."
To create an IF statement with text, based on the data mentioned above:
( IF(Sum(Deals,Status="won",Value)>50000,"Yes","No") )
- Select "Text" in number formatting.
- You can also choose to add conditional colors for the formula to return, for example, "Yes" in green and "No" in red.
- To finish and create the formula, click "Save" in the bottom-right of the page.
An example of adding conditional colors in the formula editor.
The formula will check if the total value of won deals is greater than 50.000. If the statement is true, the formula will return "Yes." Alternatively, if the statement is false, the formula will return "No."