Excel – Compare data of two different columns – IF Function

Sometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function. Syntax: IF (logical_condition, value_if_true, value_if_false) Example: Say we have two columns as Now we can use the IF function as IF (A1=B1, TRUE, FALSE) According to our IF condition if the data value of column A and column B are equal/matched then “True” value will be displayed in the  Column C otherwise “False” will be displayed.

» Read more