CIS 105 Lecture Notes - Lecture 4: George Boole, Order Of Operations
Document Summary
Functions- algebra that has been done for you. Arguments- what you give the function: can be:numbers, cell references, array references, formulas. Value- what the function gives back to you. In your worksheets, put formulas, not the results of formulas. If you can reference a cell rather than entering a value, do so. What"s the difference: interest earned (or paid) over time. Rate = interest rate for the length of the period. Pv = present value = the value of the loan at the time it is taken out. Fv = future value = 0 if you pay off the loan completely <> 0 the residual value, amount of loan not paid. For example if you are leasing a car, this is what the dealer thinks will be the market value of the car at the end of the lease period. Type=0 or omitted when payment is at end of period, =1 when payment is at beginning of period.