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