Maths Help – LOG & LN

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

Google (well neeva in this case) says yes.

https://faculty.washington.edu/djaffe/natlogs.html

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…