Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Sep
24
awarded  Autobiographer
Aug
4
comment How can I calculate the sum of all positive integers less than n?
...ohhh and +1 :)
Aug
4
comment How can I calculate the sum of all positive integers less than n?
@Sinan: my apologies sir, I didn't notice that its the (value-1) not (cell-1). I haven't dealt with Excel in a while..should stick with C# :D
Aug
3
comment How can I calculate the sum of all positive integers less than n?
beat me with the code :P
Aug
3
comment How can I calculate the sum of all positive integers less than n?
assuming that column A is going to be sequential then your example works.
Aug
3
answered How can I calculate the sum of all positive integers less than n?