Excel to Analytica Mappings/Math Functions

This page shows how Excel Mathematical functions translate to Analytica equivalents

ABS(x)

Analytica equivalent:

Abs(x)

ACOS(x)

Analytica equivalent:

ArcCos(x)

ACOSH(x)

Analytica equivalent:

Ln(x+Sqrt( (x-1)*(x+1) )

ASIN(x)

Analytica equivalent:

ArcSin(x)

ASINH

Analytica equivalent:

Ln(x+Sqrt(x^2+1))

ATAN(x)

Analytica equivalent:

ArcTan(x)

ATAN2(x,y)

Analytica equivalent:

ArcTan2(y,x)

ATANH

Analytica equivalent:

Ln( (1+x)/(1-x) ) / 2

CEILING(x)

Analytica equivalent:

Ceil(x)

Analytica does not provide an equivalent to CEILING(x,significance). You can approximate this using:

Ceil( x / abs(significance) ) * significance

This is only an approximation since round-off errors can through it off slightly.

COMBIN(n,k)

Analytica equivalent:

Combinations(k,n)

COS(x)

Analytica equivalent:

Cos(x)

COSH

Analytica equivalent:

Cosh(x)

DEGREES(angle_in_radians)

Analytica equivalent:

Degrees(angle_in_radians)

EVEN(x)

Analytica equivalent:

2*Round(x/2)

EXP(x)

Analytica equivalent:

Exp(x)

FACT(n)

Analytica equivalent:

Factorial(n)

FACTDOUBLE(n)

This function is not provided by Analytica. The following user-defined function can be used:

Function FactDouble( n : scalar )
Definition: Product( Sequence(n,1,2) )

FLOOR(x)

Analytica equivalent:

Floor(x)

Analytica does not have an exact equivalent to FLOOR(x,significance), but this can be approximated as:

Floor(x/significance) * significance

This is only an approximation because numeric roundoff may cause slight descrepancies.

INT(x)

Analytica equivalent:

Floor(x)

LN(x)

Analytica equivalent:

Ln(x)

LOG(x,base)

Analytica equivalent:

Ln(x) / Ln(base)

LOG10(x)

Analytica equivalent:

LogTen(x)