Remember Me?
Menu
Home
Search
Today's Posts
Home
Search
Today's Posts
ExcelBanter
»
Excel Newsgroups
»
Excel Discussion (Misc queries)
>
LOG
Reply
LinkBack
Thread Tools
Search this Thread
Display Modes
#
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
Reply
Thread Tools
Search this Thread
Show Printable Version
Search this Thread
:
Advanced Search
Display Modes
Switch to Linear Mode
Hybrid Mode
Switch to Threaded Mode
Posting Rules
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
On
Pingbacks
are
On
Refbacks
are
On
All times are GMT +1. The time now is
10:51 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
Contact Us
ExcelBanter forum home
Privacy Statement
LinkBack
LinkBack URL
About LinkBacks