Tag Archive: logical test

Articles sur le thème : logical test

Function IF

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/

Compare 2 columns

How to compare 2 columns in Excel?  It's very simple 😄😎👍 I will show you in this post how to do this with the functions VLOOKUP for the research ISNA for the test IF to customize the final result 😉 But first, let's start with a live demo 💛❤💙💜💚 Live demo In this worksheet (yes, it's …

Continue reading »

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