10

IF() function

Use logical conditions in a formula

Rob Markwell

Last Update 4 เดือนที่แล้ว

🗒️ Description

The IF function allows users to input different values or formula based on logical expressions.


An IF statement can have two results. The first result is if your logical condition is True, the second if your comparison is False.

✏️ Syntax & variables
✅ Expected result & examples
Suppose there are two indicators i1 and i2, we can use the IF statement to check which value is greater. For example if i1 is greater than i2 then we can take the value of i1, otherwise take the value of i2
AND and OR


We can use AND and OR keywords to add logical conditions to one IF statement.


Syntax:

Was this article helpful?

0 out of 0 liked this article