LOG

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help on how to do LOG in excel, need formula for if 3.32 log (84/69) =
..284
I have try several different ways just can't get the right answer for .284
 
=3.32*LOG(84/69)

returns 0.283628
if you want 0.284 then round it:

=ROUND(3.32*LOG(84/69),2)

If the 3.32, 84 and 69 are in a cell already - say A1,B1 & C1 respecively then:

=ROUND(A1*LOG(B1/C1),2)

--
HTH


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thanks, this really helped.

Sandy Mann said:
=3.32*LOG(84/69)

returns 0.283628
if you want 0.284 then round it:

=ROUND(3.32*LOG(84/69),2)

If the 3.32, 84 and 69 are in a cell already - say A1,B1 & C1 respecively then:

=ROUND(A1*LOG(B1/C1),2)

--
HTH


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Glad it helped.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top