BIN2DEC function

BIN2DEC(number) BIN2DEC(number)

number

Text or { Text }

A binary number.

Number or { Number }

A decimal number.

Converts a binary number to a decimal number. Also consider using the more general function DECIMAL. Perform the reverse conversion using DEC2BIN.

BIN2DEC("101")BIN2DEC("101")

Returns 5.

BIN2DEC("01111011")BIN2DEC("01111011")

Returns 123.

DECIMAL("01111011", 2)DECIMAL("01111011"; 2)

Returns 123.

BIN2DEC({ "101", "01111011" })BIN2DEC({ "101"; "01111011" })

Returns the array { 5, 123 }{ 5; 123 }.