Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File size growing growing exponentially | Excel Discussion (Misc queries) | |||
Growing Degree Days Formula | Excel Discussion (Misc queries) | |||
Growing filesize without doing anything | Excel Discussion (Misc queries) | |||
annual growing rate formula or funtion needed!! | Excel Worksheet Functions | |||
Growing CF Problem | Excel Programming |