Thread: ProductLog
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default ProductLog

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.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"WilliamG" wrote:

I have discovered that the solution to a problem I am trying to solve is: B
= A + ProductLog [-Ae^-A]. I know A and, obviously, e. Is there a formula I
can type into Excel that will give me the output B? Many thanks indeed for
any help you can offer.