Note that because this is a payment, Excel will display this number in parenthesis and red font. To avoid that, insert a "-" sign in front of the PMT formula, like below.

‘Excel’ling. Understanding MS Excel functions: PMT The ‘payment’ function can be used to find out how much to invest on a regular basis to accumulate a desired corpus ...

Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.