10 Formulas Logarithms

Last updated
Save as PDF

Page ID: 361945

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

Logarithms are used in many different calculations. There is an overview on logarithms in Chapter ? that explains how logs work. In this section we are going to focus on how to use them in sheets.

LOG10

Returns the the logarithm of a number, base 10. =LOG10(value)

This is probably what you will use most often when talking about logarithms. This function will give the logarithm of a number using base 10.

LOG

Returns the the logarithm of a number given a base. =LOG(value, [base])

This is used less often but can be used to return a logarithm using any other base. This function will assume base 10 unless told otherwise

Returns the the logarithm of a number, base e (Euler's number). =LN(value)

This function gives the natural log of a number. You can also do the natural log using LOG by entering the base as "EXP(1)"

Making formula log and ln and 1/T

Video \(\PageIndex{2}\): 2:11 Video tutorial on log, ln and 1/T. (https://youtu.be/q-gALwjPj9I)