Excel in Microsoft 365: SEQUENCE inside of other Functions such as IPMT
September 30, 2020 - by Bill Jelen
After SORT, SORTBY, FILTER, and UNIQUE, the SEQUENCE and RANDARRAY functions seem pretty tame. SEQUENCE will generate a sequence of numbers.
It does not seem like this is very interesting. Who needs to generate a list of numbers?
Try putting SEQUENCE inside other functions. Here, IPMT calculates the interest in the 7th month of a loan:
Thanks to SEQUENCE, this formula calculates the interest paid during 12 months starting in month 7:
Two formulas create a forward-looking calendar:
Title Photo: chuttersnap at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.