How to compute 'special' sum

Hello! I am trying to find a way to compute the following in an Excel spreadsheet without the use of a macro:


Can I manipulate this into some form that would make it easier to put in Excel? I'm pretty stuck and any suggestions would be much appreciated!



[EDIT] Just wanted to make it clearer - My goal is to have some formula in one cell that references just one other cell to get the result.
Unfortunately, I do not believe a closed-form solution exists for the summation

S = 1/1^2 + 1/2^2 + ... + 1/n^2 = Sum of 1/k^2 from 1 to n.

The whole thing converges to 1.644934066848226436472415166646, or pi^2 / 6, as n goes to infinity.

What sort of accuracy do you need? You can always plot a range of it, and then fit a curve to it to make it look "close".
Ahh, I was afraid of that. I'll just write the macro.

Thanks for your help!


The Physics Forums Way

We Value Quality
• Topics based on mainstream science
• Proper English grammar and spelling
We Value Civility
• Positive and compassionate attitudes
• Patience while debating
We Value Productivity
• Disciplined to remain on-topic
• Recognition of own weaknesses
• Solo and co-op problem solving