Microsoft Office Tutorials and References

In Depth Information

**Session 2.2**

Figure 2-33

Logical functions

Function

Description

IF
(logical
_
test
,
value
_
if
_
true
, [
value
_
if
_
false
])

Returns the value
value
_
if
_
true
if the
logical
_
test
expres-

sion is true and
value
_
if
_
false
if otherwise

AND(
logical1
, [
logical2
,
logical3
, ...])

Returns the value TRUE if all
logical
expressions in the

function are true and FALSE if otherwise

OR(
logical1
, [
logical2
,
logical3
, ...])

Returns the value TRUE if any
logical
expression in the

function is true and FALSE if otherwise

FALSE()

Returns the value FALSE

TRUE()

Returns the value TRUE

NOT(
logical
)

Returns the value FALSE if the
logical
expression is true

and the value TRUE if the
logical
expression is false

Amanda’s budget workbook contains much of the information that she and Joseph can

use to build a more stable financial picture for themselves in the future.

Session 2.2 Quick Check

1.
What are the four principal factors in a loan?

2.
If you were to take a five-year loan for $10,000 at 7% annual interest rate, with monthly

payments, what formula would you enter to calculate the monthly payment on the loan?

3.
To calculate the present value of a loan based on a set, monthly payment, you could

use the function.

4.
What formula would you use to display the text string “Yes” if the value in cell A1 is

greater than the value in cell B1 and “No” if otherwise?

5.
To change a logical expression from FALSE to TRUE or from TRUE to FALSE, use the

function.

Review

To reinforce the tasks you

learned in this session, go

to the SAM 2003 Training

Companion CD included

with this text.

Tutorial Summary

Review

In Session 2.1, you learned about the general syntax used by all Excel functions, and you

learned about some of the Math and Statistical functions supported by Excel. You used the

SUM function in a formula to calculate income and expenses for the month of January.

You then learned how to copy and paste these formulas into other cells in the worksheet

to calculate total figures for every month of the year. You learned the difference between

the three types of cell references—relative, absolute, and mixed—and then you used an

absolute reference to calculate a running total of the net income. You learned about the

AVERAGE, MIN, and MAX functions, and then used them to summarize the entire year’s

budget figures. Once you entered the formulas that used these functions, you learned how

to copy and paste the formulas using the Auto Fill feature. You also learned how to change

the magnification of the workbook window so you can see more or less of the data in a

worksheet. Finally, you used the TODAY() function to display the current date in the

Documentation sheet.