|
Excel: Work Smarter
Conditional Logic uses the following
expressions: AND, OR, and NOT. Here are some simple examples of how
you can use these functions.
Try This: The AND Function
The AND function is only True if both parts are true.
Select: cell A4.
Go to Formula ->Logical ->AND.
Logical1: A2>3
Logical2: A3="wet"
What Do You See? The Logical formula asked two
questions: is the rainfall amount in A2 greater than 3"?
Is the
rainfall classified as "wet" in cell A3?
The
formula in this example is:
=AND(A2>3,A3="wet")
Memo to self: the formula in
cell A4 has no line breaks. Formula -> Logical
->AND |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.6. Use conditional logic in a formula 3.6.1. Using IF, AND, OR, NOT, IFERROR