4. Use the OR function to check cells for numbers
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
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