Prev Previous Post   Next Post Next
  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default

I would put z in a separte cell A1
I would put e(z) in a separate column, say A2
And have cell (A3) for p
A1: =(some numerical value)
A2=EXP(A1)
A3 =SQRT(2)*SQRT(A2+1)
For the Lambert function
A4: =-1 +sqrt(A3) - A3/3 + (11/72)*A3^(3/2)
The ellipses part means (.....) you keep adding terms until tyou get the
required precision. However the Wolfram articel does not tell how to
generate the next term in the series:
p/3, (11/72)p^(3/2), ...
This articel might help http://en.wikipedia.org/wiki/Lambert%27s_W_function
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"lucas_php" wrote
in message ...

http://functions.wolfram.com/Element...06/01/02/0001/

This formula is easy, but the [Ellipsis] its difficult:

-1 + sqrt(sqrt(2)*sqrt(exp(z)+1)) - ((sqrt(sqrt(2)*sqrt(exp(z)+1))/3) +
(11/72)*(sqrt(sqrt(2)*sqrt(exp(z)+1)^(2/3) + [Ellipsis]

the Ellipsis I don't know I do

(Sorry my english LoL)


--
lucas_php
------------------------------------------------------------------------
lucas_php's Profile:
http://www.excelforum.com/member.php...o&userid=26275
View this thread: http://www.excelforum.com/showthread...hreadid=395660



 
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



All times are GMT +1. The time now is 08:28 PM.

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"