Convert Binary Number into Decimal Number using Bin2Dec in Excel

there is one function called Bin2Dec Which converts the number in to decimal.

Syntax:

=Bin2Dec (number)

Example:

=Bin2dec(0110)

answer:

6