Excel to Analytica Mappings/Engineering Functions

BESSELI(x, n)

Analytica equivalent:

BesselI(x, Floor(n))

BESSELJ

Analytica equivalent:

BesselJ(x, Floor(n))

BESSELK

Analytica equivalent:

BesselK(x, Floor(n))

BESSELY

Analytica equivalent:

BesselY(x, Floor(n))

BIN2DEC(x)

Analytica equivalent (requires the Base Conversion Function Library):

Bin2Dec(x)

BIN2HEX(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Bin2Hex(x, places)

BIN2OCT(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Bin2Oct(x, places)

COMPLEX(re, im)

Analytica equivalent:

Complex(re, im)

To use, add the Complex Library to your model.

CONVERT

Not available in Analytica.

DEC2BIN(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Dec2Bin(x, places)

DEC2HEX(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Dec2Hex(x, places)

DEC2OCT(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Dec2Oct(x, places)

DELTA(number1, number2)

Analytica equivalent:

(number1 == number2)

ERF(lower_limit, upper_limit)

Analytica equivalent of Erf(lower_limit) is:

Erf(lower_limit)

Analytica equivalent of Erf(lower_limit, upper_limit) is:

Erf(upper_limit) - Erf(lower_limit)

ERFC(x)

Analytica equivalent:

1-Erf(x)

GESTEP(n, step)

Analytica equivalent of GESTEP(n):

(n >== 0)

Analytica equivalent of GESTEP(n, s):

(n >== s)

HEX2BIN(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Hex2Bin(x, places)

HEX2DEC(x)

Analytica equivalent (requires the Base Conversion Function Library):

Hex2Dec(x)

HEX2OCT(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Hex2Oct(x, places)

IMABS(c)

Analytica equivalent:

CAbs(c)

To use, add the Complex Library to your model.

IMAGINARY(c)

Analytica equivalent:

Im(c)

To use, add the Complex Library to your model.

IMARGUMENT(c)

Analytica equivalent:

CTheta(c)

To use, add Complex Library to your model.

IMCONJUGATE(c)

Analytica equivalent:

Complex(Re(c), -Im(c))

To use, add the Complex Library to your model.

IMCOS(c)

Analytica equivalent:

CCos(c)

To use, add Complex Library to your model.

IMDIV(inumber1, inumber2)

Analytica equivalent:

CDiv(inumber1, inumber2)

Both inumber1 and inumber2 must be complex numbers, as obtained from function Complex, and the result is complex. To use, add Complex Library to your model.

IMEXP(c)

Analytica equivalent:

CExp(c)

IMLN(c)

Analytica equivalent:

CLn(c)

To use, add Complex Library to your model.

IMLOG10(c)

Analytica equivalent:

CDiv(CLn(c), Complex(ln(10), 0))

IMLOG2

Analytica equivalent:

CDiv(CLn(c), Complex(ln(2), 0))

IMPOWER(inumber, number)

Analytica equivalent:

CPower(inumber, number)

inumber must be a complex, defined using Complex. Do not pass a real.

To use, add the Complex Library to your model.

IMPRODUCT(inumber1, inumber2)

Analytica equivalent:

CMult(inumber1, inumber2)

Both inumber1 and inumber2 must be complex numbers, as returned from Complex. This function requires that you add the Complex Library to your model.

IMREAL(c)

Analytica equivalent:

Re(c)

This function requires that you add the Complex Library to your model. «c» is a complex number as returned from function Complex.

IMSIN(c)

Analytica equivalent:

CSin(c)

«c» must be a complex number, such as returned from function Complex. This function requires that you add Complex Library to your model.

IMSQRT(c)

Analytica equivalent:

CSqrt(c)

To use, add Complex Library to your model.

IMSUB(inumber1, inumber2)

Analytica equivalent:

inumber1 - inumber2

IMSUM(inumber1, inumber12, ...)

Analytica equivalent:

inumber1 + inumber2 + ....

Also, if A is an array of complex numbers, indexed by I, you may use:

Sum(A, I)

OCT2BIN(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Oct2Bin(x, places)

OCT2DEC(x)

Analytica equivalent (requires the Base Conversion Function Library):

Oct2Dec(x)

OCT2HEX(x, places)

Analytica equivalent (requires the Base Conversion Function Library):

Oct2Hex(x, places)

See Also

• Excel to Analytica Mappings
• Standard libraries