View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 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.