in Excel: how can I make excel count 5 as 15 (5+4+3+2+1)
What is the something that you want done to the digit entered?
--
Brevity is the soul of wit.
"Carl" wrote:
I need excel to do something to whatever digit is filled out in a cell.
Like if I would fill out 3 in A1, A2 would spit out: 6 because (3+2+1=6)
This is particularly used in the sum of the years method. However I don't
need that function, I just need A2 to spit out what I mentioned already.
|