ENGINEERING

Function
Example call
Expected result

BIN2DEC

BIN2DEC(101010)

42

BIN2HEX

BIN2HEX(101010)

2a

BIN2OCT

BIN2OCT(101010)

52

BITAND

BITAND(42, 24)

8

BITLSHIFT

BITLSHIFT(42, 24)

704643072

BITOR

BITOR(42, 24)

58

BITRSHIFT

BITRSHIFT(42, 2)

10

BITXOR

BITXOR(42, 24)

50

COMPLEX

COMPLEX(3, 4)

3+4i

CONVERT

CONVERT(64, 'kibyte', 'bit')

524288

DEC2BIN

DEC2BIN(42)

101010

DEC2HEX

DEC2HEX(42)

2a

DEC2OCT

DEC2OCT(42)

52

DELTA

DELTA(42, 42)

1

ERF

ERF(1)

0.842700793

ERFC

ERFC(1)

0.157299207

GESTEP

GESTEP(42, 24)

1

HEX2BIN

HEX2BIN('2a')

101010

HEX2DEC

HEX2DEC('2a')

42

HEX2OCT

HEX2OCT('2a')

52

IMABS

IMABS('3+4i')

5

IMAGINARY

IMAGINARY('3+4i')

4

IMARGUMENT

IMARGUMENT('3+4i')

0.927295218

IMCONJUGATE

IMCONJUGATE('3+4i')

3-4i

IMCOS

IMCOS('1+i')

0.8337300251311491-0.9888977057628651i

IMCOSH

IMCOSH('1+i')

0.8337300251311491+0.9888977057628651i

IMCOT

IMCOT('1+i')

0.21762156185440265-0.8680141428959249i

IMCSC

IMCSC('1+i')

0.6215180171704283-0.3039310016284264i

IMCSCH

IMCSCH('1+i')

0.3039310016284264-0.6215180171704283i

IMDIV

IMDIV('1+2i', '3+4i')

0.44+0.08i

IMEXP

IMEXP('1+i')

1.4686939399158851+2.2873552871788423i

IMLN

IMLN('1+i')

0.3465735902799727+0.7853981633974483i

IMLOG10

IMLOG10('1+i')

0.1505149978319906+0.3410940884604603i

IMLOG2

IMLOG2('1+i')

0.5000000000000001+1.1330900354567985i

IMPOWER

IMPOWER('1+i', 2)

1.2246063538223775e-16+2.0000000000000004i

IMPRODUCT

IMPRODUCT('1+2i', '3+4i', '5+6i')

-85+20i

IMREAL

IMREAL('3+4i')

3

IMSEC

IMSEC('1+i')

0.4983370305551868+0.591083841721045i

IMSECH

IMSECH('1+i')

0.4983370305551868-0.591083841721045i

IMSIN

IMSIN('1+i')

1.2984575814159773+0.6349639147847361i

IMSINH

IMSINH('1+i')

0.6349639147847361+1.2984575814159773i

IMSQRT

IMSQRT('1+i')

1.0986841134678098+0.45508986056222733i

IMSUB

IMSUB('3+4i', '1+2i')

2+2i

IMSUM

IMSUM('1+2i', '3+4i', '5+6i')

9+12i

IMTAN

IMTAN('1+i')

0.2717525853195117+1.0839233273386946i

OCT2BIN

OCT2BIN('52')

101010

OCT2DEC

OCT2DEC('52')

42

OCT2HEX

OCT2HEX('52')

2a