Formulas+and+Functions

= **Formulas and Functions** =

__**Practical Projects and Application for Excel **__
Find the payment for different loan amounts, APRs, and number of years. Keep a food diary with associated calories for the day and use the SUM Function to track daily calories. Using a spreadsheet that you have developed, identify the number of Cells that contain certain data by using the COUNT, COUNTBLANK, and COUNTA functions.

media type="youtube" key="6c6ldaXUIMs" height="315" width="420" align="center"

=[|Functions and Solver Improvements] =

IF(logical_test,value_if_true,value_if_false)

 * ===== logical_test—logical test is an expression that evaluates to TRUE or FALSE =====
 * ===== value_if_true—resulting value if the condition is true =====
 * ===== value_if_false—resulting value if the condition is false =====


 * ===== lookup_value is a reference to a cell containing a value to look up =====
 * ===== table_array is a range containing a lookup table =====
 * ===== column index number—argument in a VLOOKUP function that identifies which lookup table column from which to return a value =====

PMT(rate,nper,pv,[fv],[type])

 * ===== rate is the periodic interest rate, such as a monthly interest rate =====
 * ===== nper is the number of total payment periods =====
 * ===== pv is the present value of the loan =====