What function do I use to calculate a Sum of Digits?
 

I need to get Excel to calculate the formula n(n+1) e.g. for the number 5
entered into a cell it would calculate 1+2+3+4+5=15. This is to enable a Sum
of Digits calculation relating to interest payments.

What function do I use to calculate a Sum of Digits?
 

=A1*(A1+1)/2
--
If this post helps click Yes
---------------
Jacob Skaria


"NikL" wrote:

I need to get Excel to calculate the formula n(n+1) e.g. for the number 5
entered into a cell it would calculate 1+2+3+4+5=15. This is to enable a Sum
of Digits calculation relating to interest payments.

What function do I use to calculate a Sum of Digits?
 

Perfect. Thank you Jacob.

"Jacob Skaria" wrote:

=A1*(A1+1)/2
--
If this post helps click Yes
---------------
Jacob Skaria


"NikL" wrote:

I need to get Excel to calculate the formula n(n+1) e.g. for the number 5
entered into a cell it would calculate 1+2+3+4+5=15. This is to enable a Sum
of Digits calculation relating to interest payments.

What function do I use to calculate a Sum of Digits?
 

=(A1^2+A1)/2


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 00:25:01 -0700, NikL
wrote:

I need to get Excel to calculate the formula n(n+1) e.g. for the number 5
entered into a cell it would calculate 1+2+3+4+5=15. This is to enable a Sum
of Digits calculation relating to interest payments.