beautypg.com

Hex2oct, 91 hex2oct – Apple iWork '09 User Manual

Page 91

background image

Chapter 5

Engineering Functions

91

HEX2OCT

The HEX2OCT function converts a hexadecimal number to the corresponding octal
number.

HEX2OCT(hex-string, convert-length)

Â

hex-string: The string representing the number to be converted. hex-string is a
string value. It must contain only the numbers 0 through 9 and the letters A through
F.

Â

convert-length: An optional value specifying minimum length of the number
returned. convert-length is a number value and must be in the range 1 to 32. If
omitted, it is assumed to be 1. If included, convert-string is padded with leading
zeros, if necessary, so that it is at least the length specified by convert-length.

Usage Notes

This function uses two’s complement notation, based on 32 bits. Therefore, negative

Â

numbers will always be 11 digits in length.

Examples

=HEX2OCT(”F”, 3) returns 017.
=HEX2OCT(“4E”) returns 116.

Related Topics
For related functions and additional information, see:

“BIN2OCT” on page 78

“DEC2OCT” on page 85

“HEX2BIN” on page 89

“HEX2DEC” on page 90

“OCT2HEX” on page 95

“Listing of Engineering Functions” on page 72

Value Types” on page 36

The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41