#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default negative log

How do I find the logarithm of a negative number without having error message
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default negative log

In article ,
says...
How do I find the logarithm of a negative number without having error message

How do you define the logarithm of a negative number?
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 837
Default negative log

If you are talking about complex numbers (involving i=SQRT(-1)), then use
IMLN(), IMLOG10(), or IMLOG2(). Otherwise you need to be more precise about
what you want.

Jerry

"Ebotoks" wrote:

How do I find the logarithm of a negative number without having error message

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I want to get negative hours if subtraction of hours is negative hema Excel Worksheet Functions 5 April 30th 07 10:02 AM
Set negative numbers to zero. Do not calculate with negative valu Excel Headache Excel Discussion (Misc queries) 4 September 14th 06 08:56 PM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM
Negative Zero ??? Nih Excel Discussion (Misc queries) 1 August 25th 05 10:06 PM
2003= negative number&2004= negative number How Do I Calculate gro Jason Excel Worksheet Functions 1 January 14th 05 05:24 PM


All times are GMT +1. The time now is 06:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"