Microsoft Office Tutorials and References
In Depth Information
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
Returns the value FALSE
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
To reinforce the tasks you
learned in this session, go
to the SAM 2003 Training
Companion CD included
with this text.
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