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
| Row | A |
|---|---|
| 6 | Input |
| 7 | 10 |
| 8 | 15 |
| 9 | 0 |
Record 1
=DEC2BIN(A7)Expected result1010
See the inputs and instructions for all 3 examplesCopyable 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 |