#1   Report Post  
lucas_php
 
Posts: n/a
Default PorductLog


How do I can typing this formula on excel?

http://functions.wolfram.com/Element...uctLog2/06/01/

Does'nt matter what


--
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

  #2   Report Post  
lucas_php
 
Posts: n/a
Default


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

  #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



Reply
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 02:24 AM.

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

About Us

"It's about Microsoft Excel"