Reference Updated April 8, 2026

LOG

Category: Math & numeric

Overview

Description

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

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

Syntax

`LOG('Node1', 'Node2')`

Parameter

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

  • Base (Node2): The base to use for calculation of the logarithm. The base can also be a standalone number.


Examples

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

YearValue
20252
20263
20274.5

Input node: Base

YearValue
20252
20262
20272

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

Year→ LOG Result
20251
20261.58
20272.17

FunctionWhen to use instead
LNWhen you need the natural logarithm instead of a logarithm with a custom base.
EXPWhen you need exponentiation with base e rather than a logarithmic transformation.
Was this page helpful?