MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
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...