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

  • Thread starter Thread starter NikL
  • Start date Start date
N

NikL

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.
 
Back
Top