LOG10 Function not working in Solidworks 2

[Jolyon]

Hi, first time poster here - please let me know if I posted in the wrong place!

I have an issue with Solidworks that I cannot find the answer to anywhere.. I am trying to set a dimension using a Logarithmic formula with Base 10. In Microsoft Excel if I use the formula LOG(2) I get 0.30103 but in Solidworks, the Base seems to be 16 and gives me 0.6931. I looked it up and it seems that Solidworks has a LOG10 function for exactly this use (

http://help.solidworks.com/2021/english/SolidWorks/motionstudies/r_LOG10_Function_SWMotion.htm).

The problem is, when I enter LOG10(2) into the dimension box, it doesn't recognise it as a formula.

Does anyone know what I'm doing wrong, or if there is a fix for this?

Thank you in advance!

 

[handleman]

I know this is late, but just for completeness...

The base is not 16, it's e. SolidWorks equations use the VBA log function, which is the natural logarithm. Please see

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/log-function

As noted in the link above, you can calculate the logarithm in base 10 by dividing the natural logarithm by the natural logarithm of the desired base. So, to get log10 of 2, you would use log(2)/log(10).

The reason the LOG10 function you found doesn't work is because you found it in the help for SolidWorks Motion, not SolidWorks.

 

[Jolyon]

Thank you so much handleman! I just tested it and "log(2)/log(10)" did the job perfectly! I never would have thought of that.

Also I did not realise I was looking at the help section for Solidworks Motion!! Sorry for that!

 

[handleman]

No worries... There are so many sections in the SW online help, and it's not immediately apparent where you are, especially if you arrive on a page via a Google search or something.