Tag Archive: logical test

Articles sur le thème : logical test

Function IF – Examples

The IF function is used to customize the result of a test. If the test returns TRUE, you can return a specific result, like “Win” and if the test is FALSE, you can display in the cell “Lost”. The IF function The IF function is build with 3 parameters The test The result if the …

Continue reading

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

Compare 2 Columns

Live demo Change some values in this worksheet (yes, it’s a worksheet 😃). You will see that the color of the cell will change depending on whether or not the value exists in column E. Compare 2 columns Comparing 2 columns in Excel is very easy. Everything is based on the whether or not VLOOKUP …

Continue reading

Permanent link to this article: https://www.excel-exercise.com/compare-2-columns/