# Articles sur le thème : IF

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

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

## Calculate between two values in a range

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 the function VLOOKUP What is the problem? Let's say you have this workbook where you want to calculate the commission for …

## Weekends or weekdays in Excel

A basic job with Excel is to easily isolate the weekends and the weekdays. This is the case when you hace to build an automatic calendar for example.  The function WEEKDAY Presentation This function returns a value between 1 and 7 corresponding to the value of the day in a week. =WEEKDAY(Date,Parameter) This function is …

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