How to do a finite series in Excel in one row?

  • Thread starter Thread starter h1a8
  • Start date Start date
  • Tags Tags
    Excel
AI Thread Summary
The discussion revolves around calculating the sum of a specific mathematical expression in Excel, specifically the sum of the cube root of the exponential of the sine of the arctangent of a logarithmic function from x=1 to x=1,000,000. The solution involves using the "=SUMPRODUCT" function combined with the "ROW" function to generate the range for x. The final formula provided is: =SUMPRODUCT(POWER(EXP(SIN(ATAN(LN(3*POWER(ROW(1:1000000),2)+2*ROW(1:1000000)-3)))),1/3)). This effectively computes the desired sum over the specified range.
h1a8
Messages
86
Reaction score
4
I totally forgot how to do this (it's been a long while). I'm thinking it was "=sumproduct" feature? Anyway I'm trying to find the sum of cuberoot(exp(sin(arctan(3x^2+2x-3))))) from x=1 to x=1,000,000 in excel. I believe you input ranges for the variable x. I'm not sure. I accidentally deleted my work.
 
Last edited:
Computer science news on Phys.org
nvm, i figured it out.
I use "=SUMPRODUCT". In the place of "x" just put "ROW(1:1,000,000)"
So for Sum([e^sin(atan(ln(3x^2+2x-3)))]^(1/3),x,1,1,000,000) just do:

=SUMPRODUCT(POWER(EXP(SIN(ATAN(LN(3*POWER(ROW(1:1000000),2)+2*ROW(1:1000000)-3)))),1/3))
 
Well, the date has now passed, and Windows 10 is no longer supported. Hopefully, the readers of this forum have done one of the many ways this issue can be handled. If not, do a YouTube search and a smorgasbord of solutions will be returned. What I want to mention is that I chose to use a debloated Windows from a debloater. There are many available options, e.g., Chris Titus Utilities (I used a product called Velotic, which also features AI to prevent your computer from overheating etc...
Back
Top