ADVERTISEMENT
Public Function SUMMATION(n As Integer)
Dim i As Integer
SUMMATION = 0
For i = 1 To n
SUMMATION = SUMMATION + i
Next i
End Function
Not as such but you can do this:
=SUMPRODUCT(ROW(INDIRECT("1:" & A1)))
Where A1 holds the upper bound number (in this case 5).
ADVERTISEMENT
Excel has excellent built in function FACT() which does n! calculations.
But I don't need 1*2*3*4*5. Instead I need 1+2+3+4+5 calculation.
Excel has such built in function?
Thank You,
AK