Positive PMT

The PMT function returns the payment amount for a loan based on an interest rate and a constant payment schedule. In the example below, B6 contains a function: =PMT(B3/12,B4,B2) The PMT functions has 3 required arguments (and 2 optional arguments not covered here): 1....