# 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)

## 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)

## IMAGINARY(c)

Analytica equivalent:

Im(c)

## IMARGUMENT(c)

Analytica equivalent:

CTheta(c)

## IMCONJUGATE(c)

Analytica equivalent:

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

## IMCOS(c)

Analytica equivalent:

CCos(c)

## 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)

## 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.

## 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)

## 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)