|
Posted to microsoft.public.excel.misc
|
|
|
LOG
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 .
|