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