[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

FISHER

Syntax:

FISHER ( x )

Description: Computes the Fisher transformation at x.

Mathematical Formula:

Arguments:

Name

Type

Description

x

number

The number for which the transformation is wanted.

 

Return Type and Value: number – The Fisher transformation at x.

However, if

x ≤ -1, #NUM! is returned.

x ≥ 1, #NUM! is returned.

[Example:

FISHER(-0.43) results in -0.459896681
FISHER(0.578) results in 0.659454094

end example]