The IF Function with Excel
Discover all the tricks and mistakes you can have with the IF function
logical test
How to Compare 2 Columns in Excel
Learn how to compare two columns in Excel efficiently using simple techniques. Easy-to-follow guide with clear explanations and examples.
Convert TRUE or FALSE to 1 or 0 in Excel
When a test in Excel returns TRUE or FALSE, you can convert it to 1 or 0 with 2 different techniques. Discover these techniques in this article
Nested IF in Excel
How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the cases are explained here.
Exercise: How to build a logical test in Excel?
This exercise presents many situation where you must build a logical test. Will you be able to solve all the cases?
Build a nested IF in Excel
How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the cases are explained here.