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
The functions NOW & TODAY are very useful in Excel. It's the only way to build dynamic date to calculate gap between dates.
The VLOOKUP function helps you to return a result between 2 values. Discover how in this article.
Discover all the tricks and mistakes you can have with the IF function
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
Master the exclusive OR function (XOR) in Excel. Understand its unique logic and apply it to various scenarios to enhance your Excel skills.
Discover how you can easily find weekends or weekdays with Excel functions. No complex formulas are necessary.
A logical test Is very important in Excel because it's the starting point for a lot of functions to create dynamic dashboards.
How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the cases are explained here.
What are the 10 most useful Excel functions that you need to know? This article presents them with examples.
How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the cases are explained here.