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

  • Thread starter h1a8
  • Start date
  • Tags
    Excel
  • #1
h1a8
87
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
  • #2
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))
 
  • Like
Likes berkeman

Similar threads

  • Engineering and Comp Sci Homework Help
Replies
2
Views
10K
  • Computing and Technology
Replies
3
Views
3K
Replies
3
Views
1K
Replies
3
Views
2K
  • Calculus and Beyond Homework Help
Replies
4
Views
1K
  • Calculus and Beyond Homework Help
Replies
9
Views
1K
  • Introductory Physics Homework Help
Replies
29
Views
975
  • Programming and Computer Science
Replies
4
Views
405
Replies
1
Views
2K
  • Math POTW for University Students
Replies
1
Views
2K
Back
Top