bin2dec-positive |
BIN2DEC |
=BIN2DEC("1010") |
value |
|
bin2dec-zero |
BIN2DEC |
=BIN2DEC("0") |
value |
|
bin2dec-max-negative-two-s-complement |
BIN2DEC |
=BIN2DEC("1111111111") |
value |
|
bin2dec-negative-via-two-s-complement |
BIN2DEC |
=BIN2DEC("1111111110") |
value |
|
bin2dec-too-long |
BIN2DEC |
=BIN2DEC("11111111110") |
value |
1 |
bin2hex-positive |
BIN2HEX |
=BIN2HEX("1010") |
value |
|
bin2hex-with-places-padding |
BIN2HEX |
=BIN2HEX("1010", 4) |
value |
|
bin2hex-negative-two-s-complement |
BIN2HEX |
=BIN2HEX("1111111111") |
value |
|
bin2hex-invalid |
BIN2HEX |
=BIN2HEX("12") |
value |
1 |
bin2oct-positive |
BIN2OCT |
=BIN2OCT("1001") |
value |
|
bin2oct-with-places-padding |
BIN2OCT |
=BIN2OCT("1001", 4) |
value |
|
bin2oct-negative-two-s-complement |
BIN2OCT |
=BIN2OCT("1111111111") |
value |
|
bin2oct-places-too-small |
BIN2OCT |
=BIN2OCT("11111111", 1) |
value |
1 |
dec2bin-positive |
DEC2BIN |
=DEC2BIN(10) |
value |
|
dec2bin-with-places-padding |
DEC2BIN |
=DEC2BIN(10, 8) |
value |
|
dec2bin-negative |
DEC2BIN |
=DEC2BIN(-2) |
value |
|
dec2bin-out-of-range |
DEC2BIN |
=DEC2BIN(512) |
value |
1 |
dec2hex-positive |
DEC2HEX |
=DEC2HEX(255) |
value |
|
dec2hex-with-places-padding |
DEC2HEX |
=DEC2HEX(10, 4) |
value |
|
dec2hex-negative |
DEC2HEX |
=DEC2HEX(-1) |
value |
|
dec2hex-places-too-small |
DEC2HEX |
=DEC2HEX(255, 1) |
value |
1 |
dec2oct-positive |
DEC2OCT |
=DEC2OCT(8) |
value |
|
dec2oct-with-places-padding |
DEC2OCT |
=DEC2OCT(8, 4) |
value |
|
dec2oct-negative |
DEC2OCT |
=DEC2OCT(-1) |
value |
|
dec2oct-out-of-range |
DEC2OCT |
=DEC2OCT(536870912) |
value |
1 |
hex2bin-positive |
HEX2BIN |
=HEX2BIN("A") |
value |
|
hex2bin-with-places-padding |
HEX2BIN |
=HEX2BIN("A", 8) |
value |
|
hex2bin-negative-two-s-complement |
HEX2BIN |
=HEX2BIN("FFFFFFFFFF") |
value |
|
hex2bin-out-of-range |
HEX2BIN |
=HEX2BIN("200") |
value |
1 |
hex2dec-two-letters |
HEX2DEC |
=HEX2DEC("FF") |
value |
|
hex2dec-zero |
HEX2DEC |
=HEX2DEC("0") |
value |
|
hex2dec-negative-two-s-complement |
HEX2DEC |
=HEX2DEC("FFFFFFFFFF") |
value |
|
hex2dec-invalid |
HEX2DEC |
=HEX2DEC("G") |
value |
1 |
hex2oct-positive |
HEX2OCT |
=HEX2OCT("F") |
value |
|
hex2oct-with-places-padding |
HEX2OCT |
=HEX2OCT("F", 4) |
value |
|
hex2oct-negative-two-s-complement |
HEX2OCT |
=HEX2OCT("FFFFFFFFFF") |
value |
|
hex2oct-out-of-range |
HEX2OCT |
=HEX2OCT("40000000") |
value |
1 |
oct2bin-positive |
OCT2BIN |
=OCT2BIN("7") |
value |
|
oct2bin-with-places-padding |
OCT2BIN |
=OCT2BIN("7", 8) |
value |
|
oct2bin-negative-two-s-complement |
OCT2BIN |
=OCT2BIN("7777777777") |
value |
|
oct2bin-out-of-range |
OCT2BIN |
=OCT2BIN("1000") |
value |
1 |
oct2dec-positive |
OCT2DEC |
=OCT2DEC("17") |
value |
|
oct2dec-zero |
OCT2DEC |
=OCT2DEC("0") |
value |
|
oct2dec-negative-two-s-complement |
OCT2DEC |
=OCT2DEC("7777777777") |
value |
|
oct2dec-invalid |
OCT2DEC |
=OCT2DEC("8") |
value |
1 |
oct2hex-positive |
OCT2HEX |
=OCT2HEX("17") |
value |
|
oct2hex-with-places-padding |
OCT2HEX |
=OCT2HEX("17", 4) |
value |
|
oct2hex-negative-two-s-complement |
OCT2HEX |
=OCT2HEX("7777777777") |
value |
|
oct2hex-invalid |
OCT2HEX |
=OCT2HEX("9") |
value |
1 |
bitand-basic |
BITAND |
=BITAND(5, 3) |
value |
1 |
bitand-zero |
BITAND |
=BITAND(12, 0) |
value |
1 |
bitand-negative-error |
BITAND |
=BITAND(-1, 3) |
error-code |
1 |
bitand-exceeds-2-48 |
BITAND |
=BITAND(281474976710656, 1) |
value |
2 |
bitor-basic |
BITOR |
=BITOR(5, 3) |
value |
1 |
bitor-disjoint |
BITOR |
=BITOR(8, 4) |
value |
1 |
bitor-negative-error |
BITOR |
=BITOR(-1, 3) |
error-code |
1 |
bitxor-basic |
BITXOR |
=BITXOR(5, 3) |
value |
1 |
bitxor-self-zero |
BITXOR |
=BITXOR(7, 7) |
value |
1 |
bitxor-negative-error |
BITXOR |
=BITXOR(-1, 3) |
error-code |
1 |
bitlshift-basic |
BITLSHIFT |
=BITLSHIFT(1, 3) |
value |
1 |
bitlshift-zero-shift |
BITLSHIFT |
=BITLSHIFT(42, 0) |
value |
1 |
bitlshift-negative-shift-acts-as-rshift |
BITLSHIFT |
=BITLSHIFT(16, -2) |
value |
2 |
bitlshift-negative-number-error |
BITLSHIFT |
=BITLSHIFT(-1, 2) |
error-code |
1 |
bitrshift-basic |
BITRSHIFT |
=BITRSHIFT(16, 2) |
value |
1 |
bitrshift-zero-shift |
BITRSHIFT |
=BITRSHIFT(42, 0) |
value |
1 |
bitrshift-negative-shift-acts-as-lshift |
BITRSHIFT |
=BITRSHIFT(1, -3) |
value |
2 |
bitrshift-negative-number-error |
BITRSHIFT |
=BITRSHIFT(-1, 2) |
error-code |
1 |
delta-equal |
DELTA |
=DELTA(5, 5) |
value |
1 |
delta-not-equal |
DELTA |
=DELTA(5, 6) |
value |
1 |
delta-default-second-zero |
DELTA |
=DELTA(0) |
value |
1 |
delta-default-second-nonzero |
DELTA |
=DELTA(1) |
value |
1 |
gestep-greater |
GESTEP |
=GESTEP(5, 3) |
value |
1 |
gestep-less |
GESTEP |
=GESTEP(2, 3) |
value |
1 |
gestep-equal |
GESTEP |
=GESTEP(3, 3) |
value |
1 |
gestep-default-step-zero |
GESTEP |
=GESTEP(-1) |
value |
1 |
erf-zero |
ERF |
=ERF(0) |
value |
|
erf-one |
ERF |
=ERF(1) |
value |
|
erf-negative |
ERF |
=ERF(-1) |
value |
|
erf-two-arg-lower-upper |
ERF |
=ERF(0, 1) |
value |
|
erf-precise-zero |
ERF.PRECISE |
=ERF.PRECISE(0) |
value |
1 |
erf-precise-one |
ERF.PRECISE |
=ERF.PRECISE(1) |
value |
|
erf-precise-negative |
ERF.PRECISE |
=ERF.PRECISE(-0.5) |
value |
|
complex-basic |
COMPLEX |
=COMPLEX(3, 4) |
value |
2 |
complex-real-only |
COMPLEX |
=COMPLEX(5, 0) |
value |
2 |
complex-imaginary-only |
COMPLEX |
=COMPLEX(0, 1) |
value |
2 |
complex-negative-imaginary |
COMPLEX |
=COMPLEX(3, -4) |
value |
2 |
complex-j-suffix |
COMPLEX |
=COMPLEX(3, 4, "j") |
value |
2 |
imabs-3-4-5-triangle |
IMABS |
=IMABS("3+4i") |
value |
1 |
imabs-real-only |
IMABS |
=IMABS("5") |
value |
1 |
imabs-imaginary-only |
IMABS |
=IMABS("4i") |
value |
1 |
imaginary-basic |
IMAGINARY |
=IMAGINARY("3+4i") |
value |
1 |
imaginary-real-only |
IMAGINARY |
=IMAGINARY("5") |
value |
1 |
imaginary-negative |
IMAGINARY |
=IMAGINARY("3-4i") |
value |
1 |
imreal-basic |
IMREAL |
=IMREAL("3+4i") |
value |
1 |
imreal-imaginary-only |
IMREAL |
=IMREAL("4i") |
value |
1 |
imreal-negative |
IMREAL |
=IMREAL("-3+4i") |
value |
1 |
imargument-basic |
IMARGUMENT |
=IMARGUMENT("3+4i") |
value |
|
imargument-real-positive |
IMARGUMENT |
=IMARGUMENT("1") |
value |
1 |
imargument-pure-imaginary |
IMARGUMENT |
=IMARGUMENT("i") |
value |
|
imconjugate-basic |
IMCONJUGATE |
=IMCONJUGATE("3+4i") |
value |
2 |
imconjugate-negative-imaginary |
IMCONJUGATE |
=IMCONJUGATE("3-4i") |
value |
2 |
imconjugate-real-only |
IMCONJUGATE |
=IMCONJUGATE("5") |
value |
2 |
imsum-basic |
IMSUM |
=IMSUM("1+2i", "3+4i") |
value |
2 |
imsum-three-args |
IMSUM |
=IMSUM("1+i", "2+2i", "3+3i") |
value |
3 |
imsum-cancel-imaginary |
IMSUM |
=IMSUM("1+2i", "1-2i") |
value |
2 |
imsub-basic |
IMSUB |
=IMSUB("5+6i", "2+3i") |
value |
2 |
imsub-to-zero |
IMSUB |
=IMSUB("3+4i", "3+4i") |
value |
2 |
imsub-real-only |
IMSUB |
=IMSUB("5", "2") |
value |
2 |
improduct-basic |
IMPRODUCT |
=IMPRODUCT("1+2i", "3+4i") |
value |
2 |
improduct-by-real |
IMPRODUCT |
=IMPRODUCT("3+4i", "2") |
value |
3 |
improduct-i-squared |
IMPRODUCT |
=IMPRODUCT("i", "i") |
value |
2 |
imdiv-basic |
IMDIV |
=IMDIV("-5+10i", "1+2i") |
value |
2 |
imdiv-by-real |
IMDIV |
=IMDIV("6+8i", "2") |
value |
3 |
imdiv-by-zero |
IMDIV |
=IMDIV("1+2i", "0") |
value |
|
imexp-zero |
IMEXP |
=IMEXP("0") |
value |
|
imexp-real |
IMEXP |
=IMEXP("1") |
value |
|
imexp-imaginary |
IMEXP |
=IMEXP("1+1i") |
value |
|
imlog-natural-of-1 |
IMLOG |
=IMLOG("1") |
value |
|
imlog-complex |
IMLOG |
=IMLOG("3+4i") |
value |
|
imlog10-of-10 |
IMLOG10 |
=IMLOG10("10") |
value |
|
imlog10-complex |
IMLOG10 |
=IMLOG10("3+4i") |
value |
|
imlog2-of-8 |
IMLOG2 |
=IMLOG2("8") |
value |
|
imlog2-complex |
IMLOG2 |
=IMLOG2("3+4i") |
value |
|
imcos-zero |
IMCOS |
=IMCOS("0") |
value |
|
imcos-complex |
IMCOS |
=IMCOS("1+1i") |
value |
|
imcosh-zero |
IMCOSH |
=IMCOSH("0") |
value |
|
imcosh-complex |
IMCOSH |
=IMCOSH("1+1i") |
value |
|
imcot-real |
IMCOT |
=IMCOT("1") |
value |
|
imcot-complex |
IMCOT |
=IMCOT("1+1i") |
value |
|
imcoth-real |
IMCOTH |
=IMCOTH("1") |
value |
|
imcoth-complex |
IMCOTH |
=IMCOTH("1+1i") |
value |
|
imcsc-real |
IMCSC |
=IMCSC("1") |
value |
|
imcsc-complex |
IMCSC |
=IMCSC("1+1i") |
value |
|
imcsch-real |
IMCSCH |
=IMCSCH("1") |
value |
|
imcsch-complex |
IMCSCH |
=IMCSCH("1+1i") |
value |
|
imsec-zero |
IMSEC |
=IMSEC("0") |
value |
|
imsec-complex |
IMSEC |
=IMSEC("1+1i") |
value |
|
imsech-zero |
IMSECH |
=IMSECH("0") |
value |
|
imsech-complex |
IMSECH |
=IMSECH("1+1i") |
value |
|
imsin-zero |
IMSIN |
=IMSIN("0") |
value |
|
imsin-complex |
IMSIN |
=IMSIN("1+1i") |
value |
|
imsinh-zero |
IMSINH |
=IMSINH("0") |
value |
|
imsinh-complex |
IMSINH |
=IMSINH("1+1i") |
value |
|
imtan-zero |
IMTAN |
=IMTAN("0") |
value |
|
imtan-complex |
IMTAN |
=IMTAN("1+1i") |
value |
|
imtanh-zero |
IMTANH |
=IMTANH("0") |
value |
|
imtanh-complex |
IMTANH |
=IMTANH("1+1i") |
value |
|