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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Calculating a Check Digit Routine 4
How to calculate the UPC Check Digits 4
Sum of a number's digits 7
How do I calculate age using a 12 digit social security number in MS Excel? 0
formula in excel 2
using the =page! feature to transpose a row to column 0
How to calculate the present value of a security, $5000 @ 7%, 20y. 1

Top