The Logical formula IF asked if the
data in Column C, the Net Days calculated from the Lookup table, was
less than 60. If it was less than 60, than look up the Total
in Column B. If not than, enter a zero.
2. Fill Down the Formula
Select: Cell D2.
Autofill the equation in Cells D3:D5.
The
formula in Cell D4 in this example is:
=IF(C4<60,B4,0)
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 (<,>,=)
|
|
| |
