I stipulation to find the sum of adjectives fractions near the numerator 1 after minus ln of the finishing denominator
For eg, 1/1 + 1/2 + 1/3 +1/4 +.+ 1/N - ln(N)
So how can i use microsoft excel for this
Step-by-step instructions please
thnx
Answers: 1) Put your N in cell A1.
2) imbue contained by the possible denominators:
- in A2, type 1, and in A3, type 2
- select both A2 and A3
- snatch the little black square contained by the bottom right corner of the test, and drag down to autofill as far as you want (let's read out down to row 500, but it should accommodate the utmost possible N you can expect to have)
3) flood contained by the fractions:
- surrounded by B2, type the formula =IF(A2<=$A$1,1/A2,"")
- select B2, take hold of the little black square contained by the bottom right corner, and drag as far down as near are denominators in A
4) work out your final formula:
- in B1, type the formula =SUM(B2:B500) - LN($A$1)
- replace 500 near anything your later row is contained by step 2 above
You may want the N and the totalling to other be marked when you scroll down. If so, shift to A2 and do Window - Freeze Panes.
If you want spare info, tag on more details or e-mail.
Good luck.
.