Jonathan had an excellent comment in the Principal Payment post. Why create an array formula when the Analysis Toolpack already has the CUMPRINC function. Well, I said I couldn’t find a function to do it, and I wasn’t lying. That doesn’t mean one doesn’t exist, only that I couldn’t find it.
The reason I couldn’t find it was because I don’t have the Analysis Toolpack Add-In loaded. Every time I come across an ATP function, I think, “I don’t want to load that Add-In for one function”. So I don’t. But if I would just load it, then the next five times I need an ATP function, I wouldn’t have to say that.
So the question of the day is:
|Do you have the Analysis Toolpack Add-in Loaded?|
|Yes, I use many functions from the ATP|
|Yes, I use one function from the ATP|
|No, I’ve never needed an ATP function|
|No, I need an ATP function occassionally, but don’t want to install it|
|I’ve never heard of the Analysis Toolpack|
|Free polls from Pollhost.com|