The
previous pages demonstrated how to create, name and use Lookup
tables. Another useful set of Functions are the Logical
formulas. A Logical
formula is binary. There are only two answers: True/False, Yes/No.
It begins with a Logical Test. Say you wanted to calculate
how much money would be paid in less than 60 days? You could use a
Logical equation here.
1.
Try it: Create a Logical Formula Select
Cell D1 and type: Pay in 60 Select
Cell D1 and format the label BOLD. Select
Cell D2. Go to
Formulas->Function Library ->Logical. Click on
IF What Do
You See? Microsoft Excel will prompt you to fill in the
Arguments. Logical
Test: C2<60
Value_if_true:B2
Value_if_false: 0 (that's a zero) Please
click OK. Keep
going...!
Formulas ->Function Library ->Logical ->IF
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.4. Apply conditional logic in a
formula (<,>,=)
|
|
| |
