Nested IF in Excel
How to write nested IF in Excel? There is 3 situations and 3 functions that can be used. All the case are explained here.
logical test
Convert TRUE or FALSE to 1 or 0
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
Compare 2 Columns
You can easily compare the contain of 2 columns in Excel with the function VLOOKUP. You can also change the color for the missing values
How to use the Function IF?
Discover all the tricks and mistakes you can have with the IF function
