# How to compute 'special' sum

#### KLoux

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

$$\frac{1}{n^{2}}+\frac{1}{\left(n-1\right)^{2}}+\frac{1}{\left(n-2\right)^{2}}+...+1$$

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!

Thanks,

Kerry

[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.

#### csprof2000

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".

#### KLoux

Ahh, I was afraid of that. I'll just write the macro.

-Kerry

"How to compute 'special' sum"

### Physics Forums Values

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