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)

"Curtis" wrote:

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*LOG10(84/69)

Steve Yandl


"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 .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


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 ..284

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 .

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 .