View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default in Excel: how can I make excel count 5 as 15 (5+4+3+2+1)

oops!!

Not better, just the same.

Sorry RD

On Fri, 20 Oct 2006 16:16:33 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

I think this would work mo' bettah.

=(A1^2+A1)/2




On Fri, 20 Oct 2006 12:20:31 -0700, "RagDyer" wrote:

This should work for you:

=A1*(A1+1)/2


Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP