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

Excel - Wich Function should I use? 1
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Sum of values in column A based on 0/1 of column B 2
List all tables, including document structure 0
What Multiple functions do I need? 2
Calculating a Check Digit Routine 4
Sum of Variable Cells in a fixed Row 3
XIRR vs. IRR Function 11

Top