Microsoft Office Tutorials and References
In Depth Information
OCT2DEC
OCT2DEC
OCT2DEC converts an octal number to decimal.
=OCT2DEC(number)
The OCT2DEC 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.37. Where the Binar y Number is 10000010 and the Places is 3, the conversion to an octal
results in 202, and the conversion from an octal to the decimal is 130 in cell F5.
The octal number to convert.
NUMBER
Figure 5.37
Converts an octal
number to decimal.
OCT2HEX
Use the OCT2HEX function to convert an octal number to hexadecimal.
=OCT2HEX(number,places)
The OCT2HEX 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.38. Where the Binar y Number is 10000010 and the Places is 3, the conversion to an octal
results in 202. The conversion from an octal to the hexadecimal is 82 in cell F5.
The octal number to convert to a hexadecimal.
NUMBER
The number of characters to use.
PLACES
Search JabSto ::




Custom Search