5. Use the IF function to compare columns and return a specific result
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->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=DrkI_VS6l1Y
Hope You Like This Tutorial - Give Comments
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->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=DrkI_VS6l1Y
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment