 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
We have a calculation supplied by a client this uses LOG and is required in our logic control, but the PLC can only use Natural Logs - LN.
Is there a method or calculation to convert? Can it even be converted?
ln(x) = 2.303 * log(x)
Approximately
Care needed. XL uses LN for natural logs, other softwares might use LOG.
To convert between logs; Log10(x) = logn(x)/logn(10) where logn is natural log which XL writes as LN(). logn(10) = LN(10) = 2.3025851 which is the conversion factor above.
I much prefer log10 and log as notations to avoid confusion and try and avoid XL where possible. It's an easy source of error.
As above becareful that it is actually log base 10 as some software uses log to mean ln for some reason
Very easy to convert logarithms between any bases by just dividing by log of the base.
NB Worth checking that their original calcs do use LOG and not LN etc as many people confuse the two...