Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.1   Apply Functions in Formulas: Use the IF Function with Other Functions

Working with Logical Formulas 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