ExcelFlux

DEC2BIN function

Conversion — a decimal number to binary.

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Display small register values as binary text. Use BASE for larger positive numbers.

A worked example from the workbook

RowA
6Input
710
815
90
Record 1
=DEC2BIN(A7)

Expected result1010

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=DEC2BIN(10)
Turkish Excel · tr-TR
=DEC2BIN(10)

Expected result

“1010”

Worked examples

Display small register values as binary text. Use BASE for larger positive numbers.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 10
8 15
9 0
Case Formula Expected result
Record 1 =DEC2BIN(A7) 1010
Record 2 =DEC2BIN(A8) 1111
Record 3 =DEC2BIN(A9) 0
Microsoft Excel reference