# Articles sur le thème : Condition

## Function IF

The IF function is used to return the result of a test. If the test returns TRUE, you can return a specific result and if the test is FALSE, you return another result. The IF function The IF function is build with 3 parameters The test The result if the test is TRUE The result …

## Functions AND – OR

Functions AND and OR are 2 logic functions are used to create logical tests alone or with the IF function. Presentation of the functions These functions are use to enhance a logic test. Basically, with a logical test you compare 2 items only. But if you want to create a test with more items, you have …

## Function COUNTIF

If you need to count the number of rows corresponding to a name or a product, there is better than to use the filter. In fact, the COUNTIF function is dedicated for this. Presentation of COUNTIF The function COUNTIF requires only two parameters the range of cells where is your data the value you search …

## Function COUNTIFS

Usefulness of the COUNTIFS function The COUNTIFS function allows you to count the number of rows corresponding to criteria. In fact, it’s a bit like filtering your data and counting the rows that match your selection criteria. Except here, it’s the function that returns this number for you 👍😍😎 COUNTIFS allows you to count between 1 …

## Function SUMIFS

SUMIFS, what’s for? When you have a list of data and you need to do the sum of few cells of this list, the SUMIFS function is the one to use. Well, in fact, there is 2 functions to do this: SUMIF SUMIFS Difference between SUMIF and SUMIFS Like for the difference between COUNTIF and …

## Function LEN

Presentation of the LEN function The LEN function returns the number of characters in a cell (LEN for length 😉) =LEN(string) And that’s all? 🤔🤨😲 Yes that’s all! But it is a very useful function for the tests or in conditional formatting 😉 Remarks If you have a string with coma, point, dash, space, … the LEN …

## Function XOR

Function XOR is a new logical function that corresponds to the exclusive OR What is the XOR function? In logic, there are two ways to specify an OR context The inclusive OR. One or more of its parameters are true and the result of the test is TRUE, it is the function OR The exclusive OR. One and …

## What is a logical test in Excel

When create a logical test? Create a logical test is THE starting point for 3 important functions in Excel, like IF COUNTIFS SUMIFS But also for conditional formatting. Yes, you can automatically change the color of your cells according the result of a test. What it a logical test Logical tests are every where Is …