USE THE IF FUNCTION TO CHECK FOR LARGER, EQUIVALENT OR SMALL VALUE USING MICROSOFT EXCEL

In the previous example, two different messages were used as the result for comparing values. To check for three conditions in column A and present the result as “Column A is larger,” “equal,” or “Column A is smaller,” perform the following steps.

To compare columns and show the result:

1. Copy the previous example.

2. Select cells C2:C12 and type the following formula: =IF(A2>B2,"Column A is larger",IF(A2=B2,"equal",

"Column A is smaller")).
3. Press <-Ctrl+Enter->.

USE THE IF FUNCTION TO CHECK FOR LARGER, EQUIVALENT OR SMALL VALUE USING MICROSOFT EXCEL

Note: Up to seven IF functions can be combined in one cell.  To combine more than seven functions, use the customized  solution near the end of this chapter.

Microsoft Excel Tutorials, MS Excel Tutorials, Logical Functions in Excel, IF Function in Excel, Use the IF Function to check for larger, equivalent or small value using MS Excel, Video Tutorials of Microsoft Excel, Advanced Functions in Excel, Formulas in Excel, Using Macros & VBA Codes in Excel