Thread
:
in Excel: how can I make excel count 5 as 15 (5+4+3+2+1)
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
Posts: 22,906
in Excel: how can I make excel count 5 as 15 (5+4+3+2+1)
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
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben