Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summation Operator
Hi,
I'm trying to work out a way of getting Excel 2003 to answer y=2i+1 when i=1 initially with a final value of 10. y=(2x1+1)+(2x2+1)+...+(2x10+1) I could type it by hand however my next question requires the upper limit n to be infinity for the eqn y=1/i(i-1) when i=1 initially and the final value for i=infinity y=(1/(1(1+1))+(1/2(2+1)+...(1/infinity(infinity+1) and I eed to find the approximate answer for y when the addition of the successive terms causes a lass than 0.0001% change in y, as well as the last value for i when the program stops. Am utterly stumped! Please help, Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summation | Excel Discussion (Misc queries) | |||
summation | Excel Worksheet Functions | |||
conditional summation | Excel Discussion (Misc queries) | |||
Summation Operator | Excel Worksheet Functions | |||
Summation from a to b | Excel Worksheet Functions |