6. Use the IF function to check for larger, equivalent, or smaller values
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
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
No comments:
Post a Comment