LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default what's wrong with custom function?

Sorry, I thought of something like that, but I was stupid and quickly
checked the function in Worksheet. I didn't know that Log isn't the same
function in Sheet and in VBA.
"Dana DeLouis" wrote in message
...
Hi. Looks like J.E. caught the problem here. :) Here are some
additional ideas for consideration:

Sub Demo()
'VBA
Debug.Print Log(3811)

Worksheet Function
Debug.Print WorksheetFunction.Log(3811, 10)
Debug.Print WorksheetFunction.Log10(3811)
End Sub

returns...
8.24564690087386
3.58103894877217
3.58103894877217

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Juggernnath" wrote in message
...
LOG(3811)=3.5810389
*3.3093=11.850732
14.811-11.850732=2.9602678
SQR(2.9602678 0) = 1.72


<snip




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
tab names are wrong when printing custom footers (using [&tab] ) S Hartman Excel Worksheet Functions 1 June 4th 10 12:55 AM
what's wrong with this function? DogmaDot Excel Discussion (Misc queries) 1 February 24th 10 04:00 PM
What's wrong with this IF function. GEM Excel Discussion (Misc queries) 5 July 24th 09 11:51 PM
What is Wrong with this function?????????? TaraD Excel Worksheet Functions 2 September 8th 06 07:47 PM
What am I doing wrong with PMT function? Marc Excel Discussion (Misc queries) 6 May 6th 06 10:35 PM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"