Which of the following category of functions is used in this formula: =PMT(C10/12,C8,C9,1)?
Answer & explanation
Correct answer: option 2
The correct answer is option 2- Financial.
The formula PMT(C10/12,C8,C9,1) uses a Financial function.
PMT is a financial function that calculates the periodic payment for a loan or investment based on constant payments and a constant interest rate.