SEQUENCE inside of other Functions such as IPMT

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:

#evba #etipfree #kingexcel
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1