Functions
BIN2DEC
Convert binary to decimal
Try it
When to use it
When should I use BIN2DEC?
Use BIN2DEC to convert a binary (base-2) string to its decimal integer equivalent, for example when decoding bit-field values or permissions stored as binary strings.
Used in
Syntax
BIN2DEC(number)Examples
=BIN2DEC("101") // => 5
=BIN2DEC("1100100") // => 100
=BIN2DEC("1111111111") // => -1