View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Craig
 
Posts: n/a
Default how do i use excel's natural log function with negative number

im looking for the natural log (NL) or LOGe or e, however you choose to write
it. the exact formulae/equation i wish to enter is Um=U((1-e(-t/T)).
unfortunatley Excel doesn't like it, even when brocken down. could you help
further?

"Gary''s Student" wrote:

Your problem is imaginary:
=IMLOG2("-1+0i")
will return
4.53236014217602i

--
Gary''s Student


"Craig" wrote:

im trying to use negative numbers with excel's natural log function, and have
found it doesnt work the way im trying it anyway, has anyone out there used
negative numbers with Excel's natural log function and any sucess?