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
Excel – Compare data of two different columns
Now we can use the IF function as IF (A1=B1, TRUE, FALSE)
Excel – Compare data of two different columns
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.
If this post helps you then please comment.
