LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 947
Default Summation Operator

Hi. I posted a correction a while ago, but I still don't see it. Let me try again. I hope this isn't posted twice.

I made a mistake for #2.
When we round down, then the percentage difference between (n+1) and n has not reached our desired percentage change.
Hence, we need to Round Up.
If Chg equals 0.000001
Then

=CEILING((SQRT(Chg^2 + Chg) - Chg)/Chg,1)
Returns 1000.

With n = 1000, then this last value is
=n/(n+1)
=0.999000999000999


For the first question, when n=10, then:
=n*(2+n)
Returns 120.

--
HTH :)
Dana DeLouis


"Sapphy" wrote in message ...

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summation [email protected] Excel Discussion (Misc queries) 2 November 28th 07 05:12 PM
summation ExcelQuestion Excel Worksheet Functions 11 June 27th 07 02:28 AM
conditional summation boostm3 Excel Discussion (Misc queries) 3 June 6th 07 11:02 PM
Summation Operator LizM Excel Worksheet Functions 3 July 10th 06 06:37 PM
Summation from a to b jeblunk Excel Worksheet Functions 3 December 4th 05 02:14 PM


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"