One of the most commonly used financial functions is the payment function – the PMT() function. This formula replicates the mathematical equation below: Instead of using the mathematical equation, the Excel formula uses a much simpler list of arguments. =PMT(interest …
Tag: financial
SUBTOTAL() vs. SUM()
As an accountant, one of the frequent tasks that needs to be accomplished is the summing up of results; this can be anything from summing up ledger balances to a full income statement or balance sheet. We normally use a …