Welcome to MacBoardz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

LOG function not working

  
   Macintosh computer (Home) -> Excel RSS
Next:  reference & view same cell location from mult..  
Author Message
anatkramer

External


Since: Feb 06, 2008
Posts: 1



(Msg. 1) Posted: Wed Feb 06, 2008 3:26 pm
Post subject: LOG function not working
Archived from groups: microsoft>public>mac>office>excel (more info?)
Hi,<br>
<br>
I have tried the LOG function and it hasn't been working.<br>
For instance<br>
=LOG(7.61905,4)<br>
returns 1.464805561 wheras on my calculator the result is 1.6614038.<br>
We can simply check and see the the calculator is correct and the excel is not. Am I doing something wrong?<br>
<br>
Thanks!

 >> Stay informed about: LOG function not working 
Back to top
Login to vote
Mike Middleton

External


Since: Mar 01, 2006
Posts: 33



(Msg. 2) Posted: Wed Feb 06, 2008 3:47 pm
Post subject: Re: LOG function not working [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
anatkramer -

Why do you think your calculator is correct?

Have you checked to see if 4^1.464805561 is equal to 7.61905?

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



wrote in message

Hi,

I have tried the LOG function and it hasn't been working.
For instance
=LOG(7.61905,4)
returns 1.464805561 wheras on my calculator the result is 1.6614038.
We can simply check and see the the calculator is correct and the excel is
not. Am I doing something wrong?

Thanks!

 >> Stay informed about: LOG function not working 
Back to top
Login to vote
Carl Witthoft

External


Since: Mar 22, 2004
Posts: 423



(Msg. 3) Posted: Fri Feb 08, 2008 5:54 pm
Post subject: Re: LOG function not working [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I stuck 4^1.464805561 into Equato and got 7.61905 back,
so I would suspect :=) that is the correct value.

FWIW, in Excel vX "service release 1", the output is 1.46480556147537


Your calculator may be fouling the "roundoff" in both directions.
HTH

Carl


In article ,
"Mike Middleton" wrote:

> anatkramer -
>
> Why do you think your calculator is correct?
>
> Have you checked to see if 4^1.464805561 is equal to 7.61905?
>
> - Mike Middleton
> http://www.DecisionToolworks.com
> Decision Analysis Add-ins for Excel
>
>
>
> wrote in message
>
> Hi,
>
> I have tried the LOG function and it hasn't been working.
> For instance
> =LOG(7.61905,4)
> returns 1.464805561 wheras on my calculator the result is 1.6614038.
> We can simply check and see the the calculator is correct and the excel is
> not. Am I doing something wrong?
>
> Thanks!

--
Team EM to the rescue! http://www.team-em.com
 >> Stay informed about: LOG function not working 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
MIN function - Please explain what this statement is saying. It works, I just don't know how to explain it in plain english. =IF(MIN($E$10,E11),(E11*F11)) Cell E10 is a number I enter, in this case, 8 Cell E11 is the result of a formula, the return being 8.00 Cell..

Need the right function... - I'm working with two worksheets; one has the following columns: (1) name of sponsor, (2) level of sponsor ($ amount), (3) number of passes for that sponsor. The data on this spreadsheet is updated each time a new sponsor is obtained. The second..

SUMIF function - I am trying to use SUMIF function with Excel X, Mac OS 10.2.6 . I want to sum those amounts in col B which have dates in col A that match the month being summed. E.g. January 5, 2004, January 7, 2004, November 15, 2004. How do I set the criteria to..

Function VLOOKUP - How do I get VLOOKUP to recognize a cell reference for lookup_value? It only works when I enter a number into the lookup_value.

handout function - When printing a number of slides using the handout function (i.e. 6 slides per page), for an unknown reason only the first slide for each page will print. For example the first slide will print on page 1, the seventh slide of page 2, thirteenth on..
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]