USE THE IF FUNCTION TO COMPARE COLUMNS AND RETURN A SPECIFIC RESULT USING MICROSOFT EXCEL

As shown in earlier examples, Excel returns the value TRUE or FALSE when using the OR and AND functions. The IF function can also be used to conduct conditional tests on values and formulas.

This example compares two columns and shows the result in column C.

To return specific text after comparing values:

1. Enter in range A2:A12 values from 1 to 1000.
2. Enter in range B2:B12 values from 1 to 1000.
3. Select cells C2:C12 and type the following formula: =IF(A2>=B2,"Column A is greater or equal","Column B is greater").
4. Press <-Ctrl+Enter->.

USE THE IF FUNCTION TO COMPARE COLUMNS AND RETURN A SPECIFIC RESULT USING MICROSOFT EXCEL

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF function to compare columns and return a specific result using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel