[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

IMLOG2

Syntax:

IMLOG2 ( complex-number )

Description: Computes the base-2 logarithm of complex-number.

Mathematical Formula:

The base-2 logarithm of a complex number can be calculated from the natural logarithm as follows:

Arguments:

Name

Type

Description

complex-number

text

The complex number for which the base-2 logarithm is being computed. complex-number shall be in x + yi or x + yj text format.

 

Return Type and Value: text – The base-2 logarithm of complex-number, in x+yi or x+yj text format.

However, if complex-number is ill-formed, #NUM! is returned.

[Example:

IMLOG2("3+4i") results in 2.32192809506607+1.33780421255394i
IMLOG2("-2.5-34.6j") results in 5.11645626788577-2.37024020514877j

end example]