Wednesday, October 20, 2010

Excel logical if

Compare two columns and find out whats different.

Lets say you would like to compare col A1 and F1. Here is the logical if condition in excel you would use...

=IF(A1=F1,"","***")

The column would print *** when the values in A1 and F1 are different.

-Sunny