The IF() function (or SI in French) is one of the most common and useful functions in data management. It allows you to check a condition and return a value based on whether the condition is true or false.
➡️ The Display Name:
➡️ The Syntax: :
➡️ The Example:
In this example, the function checks if the age is greater than 18.
If true, it will return "Adult"; otherwise, it will return "Minor".
- 1 function 🔵 : IF() is the function that checks the condition.
- 1 condition 🟣 : age > 18 is the condition being tested.
- 2 values 🟡 : "Adult" is the value returned if the condition is true, and "Minor" is returned if the condition is false.
The Expected Result:
- If the age is greater than 18, the function will return "Adult".
- If the age is less than or equal to 18, the function will return "Minor".
💡 Practical Use:
- Check if stock is sufficient
- Calculate a discount based on the amount
- Check if an order has been shipped
- Determine the validity of a date
- Assign a category based on a score
- Verify if an invoice is paid
- Calculate shipping costs based on weight
- Assign a grade based on a threshold...
💡 You can combine the IF() function with other functions like IS_EMPTY() to check both the presence of data and its value. |
The IF() function is a versatile and powerful tool that allows you to introduce conditional logic into your formulas.
Before You Start
Getting Started with Formulas
The new formulas in Timetonic allow you to transform, calculate, and manipulate the information stored in your columns by combining multiple functions...
Or Continue With
Glossary View of Formulas
Quickly find the function or operator you're looking for or simply explore and learn how to use them...