n cell C7 type a PMT function to calculate the monthly payment for the Lon amount in B7 and the rate and number of payments determined by B2 and B3. Notice you are to calculate a monthly payment but B3 are annual values. Place a minus sign between = and PTM to convert the payment to a positive number. Copy the formula in C7 to C8. Did you property use absolute and relative references so the formula would copy correctly?
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
In cell C7 type a PMT function to calculate the monthly payment for the Lon amount in B7 and the rate and number of payments determined by B2 and B3. Notice you are to calculate a monthly payment but B3 are annual values. Place a minus sign between = and PTM to convert the payment to a positive number. Copy the formula in C7 to C8. Did you property use absolute and relative references so the formula would copy correctly?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
