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

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

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

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

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