Pages

Saturday, December 11, 2010

Use the OR function to check cells for numbers - Logical Functions - Microsoft Excel Tutorials

4.  Use the OR function to check cells for numbers

A worksheet contains several values in column A. Each row has to be evaluated based on certain criteria in column A. The OR function is used for this task. The function returns TRUE if any argument is TRUE and FALSE if all arguments are FALSE.

Note: Up to 30 conditions can be used in one formula.

To check for two or more criteria:

1. Enter in range A2:A12 values from –43 to 100.
2. Select cells B2:B12 and type the following formula: =OR(A2=1,A2>=99,A2<0).
3. Press <-Ctrl+Enter->.



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

  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