SUM from 1 to n in EXCEL
Solved
Julien
-
To -
To -
Hello,
I would like to sum the a^i, with i going from 1 to n, in a single Excel cell.
In expansion, this would give: a^0 + a^1 + a^2 + ... + a^n.
I've been looking for a while, and I'm stuck...
Thank you in advance for your help
I would like to sum the a^i, with i going from 1 to n, in a single Excel cell.
In expansion, this would give: a^0 + a^1 + a^2 + ... + a^n.
I've been looking for a while, and I'm stuck...
Thank you in advance for your help
Configuration: Windows Vista Firefox 3.0.13
6 réponses
Hello,
In Excel, the formula does not exist, so you need to create it:
In a module (like a macro), write the code for this function (which I called sommepuiss in the example below)
Then, in the Excel sheet, use it as a "classic" function:
If a is in A1 and n in A2, for example, you should write in the cell where you want the result:
=sommepuiss(A1;A2)
--
If you need anything else, just let me know.
In Excel, the formula does not exist, so you need to create it:
In a module (like a macro), write the code for this function (which I called sommepuiss in the example below)
Function sommepuiss(V, n) For i = 0 To n sommepuiss = sommepuiss + V ^ i Next i End Function
Then, in the Excel sheet, use it as a "classic" function:
If a is in A1 and n in A2, for example, you should write in the cell where you want the result:
=sommepuiss(A1;A2)
--
If you need anything else, just let me know.
I would like to create a function in Excel that allows me to perform a "while" loop (it's for an algorithm). And I find that a "while K <= N" loop is like "for K from 1 to N"
Since I can't find the "while" loop, I'm leaning more towards the second solution
However, I'm not sure about the code to enter when creating my function, and a bit of help from someone who knows would not be too much.
Thank you in advance, and have a good day!