Pages

Saturday, December 11, 2010

Use the IF function to compare columns and return a specific result - Logical Functions - Microsoft Excel Tutorials

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

No comments:

Post a Comment

Submit Site to Google Free Articles Search Engine Submission - AddMe Directories Suggest Link Business Directory AutoBackLinks Directory Bingo Bahia Submission Software Reviews