Formulas and Functions

BIN2DEC
The BIN2DEC function converts a binary number to the corresponding decimal
number.
BIN2DEC(binary-string, convert-length)
 binary-string: The string representing the number to be converted. binary-string is
a string value. It must contain only 0s and 1s.
 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 specied by convert-length.
Examples
=BIN2DEC(”1001”) returns 9.
=BIN2DEC(”100111”, 3) returns 039.
=BIN2DEC(101101) returns 45.
Related Topics
For related functions and additional information, see:
“BIN2HEX” on page 77
“BIN2OCT” on page 78
“DEC2BIN” on page 83
“HEX2DEC” on page 90
“OCT2DEC” on page 94
“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
76 Chapter 5 Engineering Functions