WorksheetFunction.FisherInv (Excel)

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

If y is nonnumeric, FisherInv returns the #VALUE! error value. The equation for the inverse of the Fisher transformation is

FisherInv (Arg1)

Arg1: y - the value for which you want to perform the inverse of the transformation.

Dim dblArg1 As Double: dblArg1 = 
Dim dblFisherInv As Double
dblFisherInv = WorksheetFunction.FisherInv(Arg1:=dblArg1)