Tag Archive: IF

Articles sur le thème : IF

Function IF – Examples

Result if the amount is correct or not

Discover all the tricks and mistakes you can have with the IF function

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

Functions AND – OR

Formula to find people who get married with one child

The functions AND or OR are very useful if you have to create a test on more than 1 criteria. Have a look at the examples in this article

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

NOW & TODAY

The function TODAY will update the result every day

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/

Create test on String Length

Function IF with a test based on the length of the ID

The LEN function returns the number of characters is a cell. It’s very useful if you have to check the length of names, codes, references, …

Permanent link to this article: https://www.excel-exercise.com/create-test-on-string-length/

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/