Tag Archive: IF

Articles sur le thème : IF

Function IF – Examples

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-function-excel/

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 very useful with logical tests. 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 these functions. …

Continue reading

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

NOW & TODAY

The functions TODAY and NOW are 2 functions extremely important. They allow you to create dynamic workbooks using the system date on your computer. We will use these functions to create workbooks such as Automatic calendar Worker timesheet Follow-up of supplier payments Delivery delays … Presentation of the functions To view the current day, use …

Continue reading

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

Weekends or weekdays in Excel

Separating weekends and weekdays is a basic job in Excel. For example, when you have to build an automatic calendar.  The function WEEKDAY Presentation This function returns a value between 1 and 7 corresponding to the value of the day of the week. =WEEKDAY(Date,Parameter) This function is very, very, VERY useful for creating a test …

Continue reading

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

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 …

Continue reading

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

Function LEN – Test a String Length

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 useful for logical tests or for conditional formatting Remarks If you have a string containing a comma, point, dash, space, etc. the LEN function counts every …

Continue reading

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

Function XOR

Function XOR Excel

Function XOR is a logical function integrated into Excel.

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 What it a logical test Logical tests are everywhere. Is my salary higher than my colleague’s? Is my rent higher than my neighbour’s? Is the quantity in stock larger now …

Continue reading

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