Thread: ProductLog
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default ProductLog

If I can assume that ProductLog = we^w then do this

Hi. I don't believe that is correct.
A quick copy form Help in a math program...

ProductLog[z] gives the principal solution for w in z=we^w.

For Excel, we need to solve via iteration AFAIK.

Dana DeLouis



Barb Reinhardt wrote:
If I can assume that ProductLog = we^w then do this

Let's also assume the your value of w (from the above) is in cell A1

Product Log =A1*EXP(A1)

FWIW, I had to Google this function. I don't believe that there is a built
in function in Excel, but you could create a UDF if you use it enough.