View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default how do i use excel's natural log function with negative numbers?

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?