## 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