LOG and LOG10

Use LOG to insert the logarithm of the value for a base. This enables you to represent very high values using a smaller frame of reference. For example, LOG is used to assess seismic activity such as earthquakes.

LOG uses this syntax: LOG(value, base)). For exampl, LOG(4, 100,000))= 0.12

Use LOG10 to insert the base-10 logarithm of a number that you specify. This function uses this syntax:

For example, LOG10(86)=1.93449

  To use this function:

  1. Select Functions, then Mathematical.

  2. Double-click LOG or LOG10.

  3. Replace value and base with the numbers to use.