Thread
:
LOG
View Single Post
#
1
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
LOG
Glad it helped.
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Curtis" wrote in message
...
Thanks, this really helped.
"Sandy Mann" wrote:
=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
Replace @mailinator.com with @tiscali.co.uk
"Curtis" wrote in message
...
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 .
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann