Help Center

Log in

Plecto

IF Statements

IF statements in the Advanced editor

For IF statements, you need to use the Advanced formula editor. Plecto's IF statements work similarly to those in Excel, using the following syntax:

( IF(<function>(<data source>)[condition], [if_true], [if_false] ) )

The condition can only be a numerical value. Plecto doesn't support text conditions.

Example

If the number of booked meetings is 40 or more, show "Target reached." If not, show "Target not reached". Required number format: Text.

( IF(Count(Booked meetings) >= 40, "Target reached", "Target not reached " ) )

Nested IF statements

You can include additional IFs inside the statement's [if_true],[if_false] fields.

In the example below, the formula checks if the number of sales is greater than 0 and if the sum of sales is greater than 0.

If both are true, the formula will return 1; otherwise, it will return 0.

( IF(Count(Sales)>0, IF(Sum(Sales)>0, 1, 0 ), 0 ) )

Breakdown:

  • >0 – condition

  • IF(Sum(Sales)>0,1,0) – if true

  • 0 – if false

IF Statement That Returns YES or NO →

IF Statement That Returns Text →

IF Statement That Returns Different Static Numbers →

Relatel Smileys

Show a smiley face when the rating is 1, an angry smiley when the rating is 0.

Number format: Text

( IF(Last(Relatel Smileys,Rating)=1, "😊", "😡" ) )