Results 1 to 9 of 9

Thread: Lambert W function for Excel, work on real and complex number

Threaded View

  1. Jun 29th, 2012, 05:31 PM #1
    manandpc
    manandpc is offline

    Thread Starter
    New Member
    Join Date
    Apr 2012
    Posts
    8

    Thumbs up Lambert W function for Excel, work on real and complex number

    The Lambert W function (very efficient, fast)

    See, LambertW.bas to get the VB module (attach)

    Input: real or complex values from -infinity to +infinity
    You can verify the results with

    =IMSUM(IMPRODUCT(LambertW(COMPLEX(-100,0)),IMEXP(LambertWc(-100,0))),-1)
    return:
    -100.999999999999+8.5265128291212E-14i

    OR

    =IMPRODUCT(LambertW(-0.1),IMEXP(LambertW(-0.1)))
    return:
    -0.1

    Lots of testing, no error found
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width