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

The IF() function is a versatile and powerful tool that allows you to introduce conditional logic into your formulas.