|
3. Try it: Enter the
Function Arguments Type: Above
for the true values. Type:
Below for the false values. Excel will put
the quote marks (" ") around the text that you type. Click OK
to finish the formula.
The equation, as
it is written, uses relative references.
If you copy and
paste
this equation, you may not get the results that you wanted.
4. Try This: Practice the IF Formula
For practice,
use the Formula tools to create the IF Logical
equation in Cell E3 and Cell E4.
Very good. You can save this spreadsheet if you wish.
Exam 77-882: Microsoft Excel 2010
Core
5. Applying Formulas and Functions
5.4. Apply conditional logic in a
formula (<,>,=): IF
|
|
| |
