How does it work?
Currently, you can only write IF statements in the Advanced formula editor.
Plecto's IF statements work similarly to those in Excel with the following syntax:
( IF(<function>(<data source>)[condition],[if_true],[if_false]) |
Example
If the number of booked meetings is 40 or more, show "Target reached." If not, show nothing. Change the number format to Text.
( |
Nested IF statements
You can include additional IF statements inside an IF statement's [if_true],[if_false] fields.
In the example below, the formula will check whether the number of sales is greater than 0 and also if the sum of sales is greater than 0. If both are true, the formula will return 1; otherwise, it will return 0.
( IF(Sum(Sales)>0,1,0), |
Breakdown:
>0 – condition
IF(Sum(Sales)>0,1,0) – if true
0 – if false