# Formulas: IF condition

**Description**

The IF condition does one operation or another depending on a defined math expression.

Math expressions and conditions can be as complex as necessary, they can be nested or include boolean operators.

**Formats**

#### IF ( expression, operation_if_true)

In this format if the expression is true, the operation is done.#### IF ( expression, operation_if_true, operation_if_false)

In this second format, if the expression is true, the first operation is done.If false, then the second one proceeds

### Example 1

This first formula is read like this,

**IF Test1 is greater than 60, show the green smiley icon**

The formula looks like this

And this is the result

### Example 2

Similar to our previous example but in this one we will use the second format of the IF condition. If the first expression matches, it performs the first operation, if not, the second one.It is read like this,

**IF test1 is greater than 60 show a green smiley icon, if not show red smiley icon**

The previous formula can also be expressed like this. Note the less than or equal sign in the second condition so that all possible outcomes are taken into account

#### Example 3

We will see in this example the unlimited options of the first expression we put in a conditionIn this formula, we will show a yellow smiley if TEST1 value is greater than 60 but lower than 80

The formula will look like this