LOG

In Math & numeric

The LOG function returns the logarithm of a number (first argument) with respect to a base (second argument), while retaining all dimensions.

Use this function when you need a logarithm with a specific base rather than the natural logarithm.

Parameters

Value (Node1)Node referenceRequired

The value for which to calculate the logarithm, specified using the node name in single quotes (e.g. 'Profit')

Base (Node2)Node reference or numberRequired

The base to use for calculation of the logarithm. The base can also be a standalone number.

Example

Logarithm with a custom base

This example calculates the logarithm of input values using a separate node to define the base for each year.

Input node: 'Value'

Input node: 'Base'

Formula: LOG('Value', 'Base')

See also

LN

When you need the natural logarithm instead of a logarithm with a custom base.

EXP

When you need exponentiation with base e rather than a logarithmic transformation.