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.
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