Use the LAMBDA() function to create a loan amortization schedule!
Tag: formula
LET Function in Excel: A Name Parsing Example
The LET function is one of the most exciting formulas to be added to Excel in 2020. This formula allows a spreadsheet maker the ability to create names for calculations (within a cell). These names not only make your formulas …
Using PMT() to calculate installments
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 …
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 …