|
Excel: A Question of Balance
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 Fill Down
this equation, you may not get the results that you wanted.
For practice,
use the Formula tools to create the IF Logical
equation in Cell E3 and Cell E4.
|
|||||
|
| |||||
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