Scooterman23
New Member
- Joined
- May 9, 2015
- Messages
- 7
In excel, SUM(number 1, [number 2], ...) is used to sum an array of cells, however, I'm trying to go back to the mathematical usage of summation:
n
Σ f
= f(1) + f(2) + ... + f(n-1) + f
i = 1
I'm trying to use this to plug in values to a function such as PV(i%, n,, F) to sum present worth values with a constant i% and F value and a varying n without making an array of PV values.
I have a feeling that excel won't be able to do this but I'd like to try.
Thanks in advance!
n
Σ f


i = 1
I'm trying to use this to plug in values to a function such as PV(i%, n,, F) to sum present worth values with a constant i% and F value and a varying n without making an array of PV values.
I have a feeling that excel won't be able to do this but I'd like to try.
Thanks in advance!