Use the IF function to check for larger, equivalent, or smaller values - Logical Functions - Microsoft Excel Tutorials

6.  Use the IF function to check for larger, equivalent, or smaller values

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->.

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.



Watch the Video Tutorial - https://www.youtube.com/watch?v=CbmCL1OvC88

Hope You Like This Tutorials, Give Comments