LOG

Calculates the logarithm of a number to a specified base

Updated over a week ago

Description

The LOG() function computes the logarithm of a given number to a specified base. It's useful for understanding exponential relationships, such as in finance or scientific calculations.

Syntax

LOG(number, base)

Output

number

Variables

  1. number: The numeric value for which you want to find the logarithm.

  2. base: The base to which you want to calculate the logarithm. [If not specified, it defaults to base 10.]

Example

LOG(`Price (USD)`*`Quantity Sold - NY`, 2)

Product

Price (USD)

Quantity Sold - NY

LOG

Product A

25.99

150

11.929

Product B

14.75

280

12.012

Product C

7.99

500

11.964

Product D

35.20

90

11.629

Product E

50.00

120

12.551

Did this answer your question?