Numtobase, 92 numtobase – Apple iWork '09 User Manual

Page 92

Advertising
background image

NUMTOBASE

The NUMTOBASE function converts a number from base 10 into a number in the
specified base.

NUMTOBASE(decimal-string, base, convert-length)

Â

decimal-string: The string representing the number to be converted. decimal-string
is a string value. It must contain only the numbers 0 through 9.

Â

base: The new base of the number to be converted. base is a number value and
must be in the range 1 to 36.

Â

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.

Examples

=NUMTOBASE(16, 16) returns 10.
=NUMTOBASE(100, 32, 4) returns 0034.
=NUMTOBASE(100,2) returns 1100100.

Related Topics
For related functions and additional information, see:

“BASETONUM” on page 73

“DEC2BIN” on page 83

“DEC2HEX” on page 84

“DEC2OCT” on page 85

“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

92

Chapter 5

Engineering Functions

Advertising