Microsoft Office Tutorials and References
In Depth Information
OCT2BIN
Figure 5.35
Returns the sum of two
complex numbers x+yi
or x+yj in text format.
OCT2BIN
Converts an octal number to binar y with the OCT2BIN function.
=OCT2BIN(number,places)
The OCT2BIN function is found only if the Analysis Toolpak is installed. In addition it must be
turned on in the Add-Ins from the Tools menu. The number cannot be more than 10
characters. The sign bit being the most significant, the remaining 29 bits are magnitude bits.
Negatives are represented using Two’s complement notation. Notice the example in Figure
5.36. Where the Binar y Number is 10000010 and the Places is 3, the conversion to a Octal
results in 202, and the conversion back to the binar y results in 10000010.
The number in which to convert. If the number is negative it
ignores the places and returns 10-character binar y. The number
cannot be greater than 777 and less than or equal to 7777777000.
NUMBER
The number of characters to use.
PLACES
Figure 5.36
Converts an octal
number to binary number.
Search JabSto ::




Custom Search