USE THE IF FUNCTION TO COMPARE THE TWO CELLS USING MICROSOFT EXCEL

The following tip is a solution for comparing two cells line by line.  Prepare a new worksheet, filling the first two columns with the values 0 and 1 as shown in Figure 2-12.

To compare cells line by line:

1. Select cells C2:C11 and type the following formula:
=IF(A2&B2="11","OK",IF(A2&B2="10","First Value is OK",IF(A2&B2="01","Second Value is OK",”Both Values are FALSE”))).
2. Press <-Ctrl+Enter->.

USE THE IF FUNCTION TO COMPARE THE TWO CELLS USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, AND Function in Excel, Use the IF function to compare the two cells using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel