| Functions in English | Functions in French | Description of Function |
|---|
| AND | ET | Returns TRUE if all of its arguments are TRUE. |
| BYCOL | BYCOL | Applies a LAMBDA to each column and returns an array of the results (365). |
| BYROW | BYROW | Applies a LAMBDA to each row and returns an array of the results (365). |
| FALSE | FAUX | Returns the logical value FALSE. |
| IF | SI | Specifies a logical test to perform. |
| IFERROR | SIERREUR | Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. |
| IFNA | SI.NON.DISP | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression (2013). |
| IFS | SI.CONDITIONS | Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition (2016). |
| LAMBDA | LAMBDA | Create custom, reusable functions and call them by a friendly name (365). |
| LET | LET | Assigns names to calculation results (365). |
| MAKEARRAY | MAKEARRAY | Returns a calculated array of a specified row and column size, by applying a LAMBDA (365). |
| MAP | MAP | Returns an array formed by mapping each value in the array(s) to a new value by applying a LAMBDA to create a new value (365). |
| NOT | NON | Reverses the logic of its argument. |
| OR | OU | Returns TRUE if any argument is TRUE. |
| REDUCE | REDUCE | Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator (365). |
| SCAN | SCAN | Scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value (365). |
| SWITCH | SI.MULTIPLE | Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned (2016). |
| TRUE | VRAI | Returns the logical value TRUE. |
| XOR | OUX | Returns a logical exclusive OR of all arguments (2013). |