Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>formula

Tag: formula

Updated on March 12, 2022March 12, 2022/ Brent Allen

LAMBDA() in Excel – Generating an Amortization Schedule

LAMBDA() in Excel – Generating an Amortization Schedule

Use the LAMBDA() function to create a loan amortization schedule!

Read More
Updated on December 10, 2020December 10, 2020/ Brent Allen

LET Function in Excel: A Name Parsing Example

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 …

Read More
Updated on November 4, 2019October 11, 2019/ Brent Allen

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 …

Read More
Updated on November 4, 2019October 5, 2019/ Brent Allen

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 …

Read More

Recent Posts

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2025 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.