LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Calculating a growing formula


Hi,

I'm having a little problem. I'm trying to calculate a formula whic
grows for every calculation I must make. I always have to use th
solver so it takes a while to get it done. Here is my problem.

For x that goes from 1 to 30 (all integers), I want to evaluate "m".
also want the result of the equation to be 0.95 so here how it goes:

For x=0: 0.95 = exp(-m) - m = 0.051
For x=1: 0.95 = exp(-m) * (1+m) - m = 0.355
For x=2: 0.95 = exp(-m) * (1+m+m²/2) - m = 0.818
For x=3: 0.95 = exp(-m) * (1+m+m²/2+m³/6) - m = 1.366
For x=4: 0.95 = exp(-m) * (1+m+m²/2+m³/6+(m^4)/24)
and so on...

As you may notice, the denominator is the factorial of the exponent o
"m". So, I was wondering if there was a way to simplify thos
calculations....

THank

--
bambinos8
-----------------------------------------------------------------------
bambinos83's Profile: http://www.excelforum.com/member.php...fo&userid=3258
View this thread: http://www.excelforum.com/showthread.php?threadid=55658

 
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
File size growing growing exponentially Steve Excel Discussion (Misc queries) 3 May 24th 09 06:29 PM
Growing Degree Days Formula jdonnelly333 Excel Discussion (Misc queries) 4 April 30th 09 08:55 PM
Growing filesize without doing anything Mike Excel Discussion (Misc queries) 0 June 21st 07 09:56 AM
annual growing rate formula or funtion needed!! Ivan Excel Worksheet Functions 1 October 24th 06 12:48 PM
Growing CF Problem David McRitchie[_2_] Excel Programming 0 September 29th 03 05:04 PM


All times are GMT +1. The time now is 03:41 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"