The SI function

The SI (IF) function tests a condition and returns one value if it is true and another if it is false. Its syntax is SI(test; valeur_si_vrai; valeur_si_faux). The test uses comparison operators such as >, <, =, <>. It lets you classify, flag or calculate according to a criterion.

Example

=SI(B2>=10;"Admis";"Refusé")  // "Admis" = passed, "Refusé" = failed

Related concepts

The whole glossary