Tag Archive: IF

Articles sur le thème : IF

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 …

Continue reading »

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

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 …

Continue reading »

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

Calculate between two values

In Excel, you can easily return a result between two values. Most of the people think that they have to do a lot of IF nested. But you can do the same job with one function: VLOOKUP What is the problem? Let’s say you have this workbook where you want to calculate the commission for …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/calculate-between-two-values/

The WEEK functions

Problems of calculation with week The first problem it’s the weekends (you know, these days we stay quiet at home watching TV). We can not include these days in a work day calculation. And do you know that for some countries in the world, the weekend is not Saturday and Sunday? Yes, some Arabic countries …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/the-week-functions/

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 …

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

Continue reading »

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