BIN2DEC

Definition: BIN2DEC is a function that converts a binary number to decimal.

Syntax: =BIN2DEC(number)

Situation: This formula is suitable when you need to convert a binary number to decimal for use in a calculation.

Example: If you have a binary number 1010, the decimal equivalent can be found using the formula =BIN2DEC(1010), which returns 10.