Tag Archive: Condition

Articles sur le thème : Condition

Function IF

The IF function is used to customize the result of a test. If the test returns TRUE, you can return a specific result, like "Win" and if the test is FALSE, you can display in the cell "Lost". The IF function The IF function is build with 3 parameters The test The result if the …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/if/

Functions AND - OR

Functions AND and OR are 2 logic functions that help you to create sophisticate logical tests. 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 to use one …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-and-or/

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. But the function COUNTIF accepts only one criteria of selection. If you want to count your row for more than one criteria, …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/countif/

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 …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/countifs/

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 …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/sumifs/

Function LEN

Presentation of the LEN function The LEN function returns the number of characters in a cell. It's simple 😉 =LEN(string) And that's all? 🤔🤨😲 Yes that's all! But this function is very usefull for the tests or for the conditional formatting Remarks If you have a string with coma, point, dash, space, ... the LEN function counts every …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-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 …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-xor/

What is a logical test in Excel

When should you create a logical test? Creating a logical test is THE starting point for these 3 important functions in Excel: IF COUNTIFS SUMIFS But it is also used 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 …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/logical-test-excel/