Products

Documentation keyboard_arrow_right Formulas keyboard_arrow_right Functions keyboard_arrow_right Dec2bin

DEC2BIN function

PRO BASIC

The DEC2BIN function in Jspreadsheet Formulas Pro is a tool that allows you to transform a decimal number into its binary format. Binary format is a numerical system used in digital electronics and mathematics, consisting only of zeros and ones. With DEC2BIN, you simply input a decimal number and the function will output its binary equivalent. This is particularly useful in computational fields where binary code is often utilized.

Documentation

Converts a decimal number to binary format.

Category

Engineering

Syntax

DEC2BIN(number, [places])

Parameter Description
number The decimal number you want to convert to binary.
[places] Optional. The minimum number of characters to use for the binary number. If omitted or zero, the function will use as many characters as necessary.

Behavior

The DEC2BIN function converts a decimal number to binary. This function takes two arguments, the decimal number to be converted and the number of characters to use. If places is omitted, the function returns the shortest binary representation of the number. If places is provided, it pads with leading zeroes to that length (up to 10 digits). The function can handle numbers, text representations of numbers, and references to cells containing numbers.

  • If the cell is empty, the function will return #NUM! error as it requires a number to function.
  • If the cell contains text that cannot be interpreted as a number, the function will return #VALUE! error.
  • If the cell contains a boolean value, it will be interpreted as 0 for FALSE and 1 for TRUE.
  • If the decimal number is negative, or if it's larger than the function can handle, it will return #NUM! error. The largest number DEC2BIN can handle is 511 for 10-bit binary numbers (default), or up to the limit of the specified number of characters.
  • If the second argument (number of characters) is not an integer between 1 and 10, the function returns #NUM! error.

Common Errors

Error Description
#NUM! Occurs if the supplied number argument is < 0 or is >= 2^places
#VALUE! Occurs if the supplied arguments are non-numeric or if the places argument is non-numeric or is less than 0

Best practices

  • Always ensure that the number you want to convert to binary is within the acceptable range (0 to 2^places - 1). If you're not sure, use a conditional statement to check the number before passing it to the DEC2BIN function.
  • Be mindful of the number of characters (bits) you specify. If you specify too few, larger numbers will result in #NUM! errors.
  • If you're dealing with negative numbers, remember that DEC2BIN cannot handle them. You'll need to use a different method to convert negative numbers to binary.
  • Although DEC2BIN can handle text representations of numbers, it's a good practice to ensure that your data is the correct type (number) to avoid unexpected #VALUE! errors.

Usage

A few examples using the DEC2BIN function.

DEC2BIN(5) ➝ 101  
// Converts 5 to binary (no padding)

DEC2BIN(42, 8) ➝ 00101010  
// Converts 42 to 8-bit padded binary

DEC2BIN(0) ➝ 0  
// Zero input returns single-digit binary

DEC2BIN(512) ➝ #NUM!  
// Exceeds binary capacity for 10 bits

DEC2BIN("ABC") ➝ #VALUE!  
// Invalid text input

Interactive Spreadsheet Demo

<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />

<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>

<div id="spreadsheet"></div>

<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
  worksheets: [{
    data: [
    [
        "Decimal",
        "Binary",
        "Binary (8 places)"
    ],
    [
        15,
        "=DEC2BIN(A2)",
        "=DEC2BIN(A2,8)"
    ],
    [
        42,
        "=DEC2BIN(A3)",
        "=DEC2BIN(A3,8)"
    ],
    [
        127,
        "=DEC2BIN(A4)",
        "=DEC2BIN(A4,8)"
    ],
    [
        255,
        "=DEC2BIN(A5)",
        "=DEC2BIN(A5,8)"
    ]
]
  }]
});
</script>
</html>

import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";

// Set license
jspreadsheet.setLicense('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default function App() {
    // Spreadsheet array of worksheets
    const spreadsheet = useRef();

    // Worksheet data
    const data = [
    [
        "Decimal",
        "Binary",
        "Binary (8 places)"
    ],
    [
        15,
        "=DEC2BIN(A2)",
        "=DEC2BIN(A2,8)"
    ],
    [
        42,
        "=DEC2BIN(A3)",
        "=DEC2BIN(A3,8)"
    ],
    [
        127,
        "=DEC2BIN(A4)",
        "=DEC2BIN(A4,8)"
    ],
    [
        255,
        "=DEC2BIN(A5)",
        "=DEC2BIN(A5,8)"
    ]
];

    // Render component
    return (
        <Spreadsheet ref={spreadsheet}>
            <Worksheet data={data} />
        </Spreadsheet>
    );
}

<template>
    <Spreadsheet ref="spreadsheet">
        <Worksheet :data="data" />
    </Spreadsheet>
</template>

<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";

// Set license
jspreadsheet.setLicense('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

export default {
    components: {
        Spreadsheet,
        Worksheet,
    },
    data() {
        // Worksheet data
        const data = [
    [
        "Decimal",
        "Binary",
        "Binary (8 places)"
    ],
    [
        15,
        "=DEC2BIN(A2)",
        "=DEC2BIN(A2,8)"
    ],
    [
        42,
        "=DEC2BIN(A3)",
        "=DEC2BIN(A3,8)"
    ],
    [
        127,
        "=DEC2BIN(A4)",
        "=DEC2BIN(A4,8)"
    ],
    [
        255,
        "=DEC2BIN(A5)",
        "=DEC2BIN(A5,8)"
    ]
]

        return {
            data
        };
    }
}
</script>

import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";

// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('NmRkMGJhYjIzZDM5Y2FhMzhlMGEwMjg4NWRkYWMzZDQ3ODNlNGNjNDYyNDc3YzhjMzQ3Yjc3ZDg5NjVlNmE5OWE0ZDI2MGQzNTdjNTJhNjFmZWI5OGRkMDk5NmI4ZTZlYjkwNmZhZDZmNjVkOTJlODhhNWE1MDhhMjJjYjEzMDUsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVNE56YzBNRE13TENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');

// Set the extensions
jspreadsheet.setExtensions({ formula });

@Component({
    standalone: true,
    selector: "app-root",
    template: `<div #spreadsheet></div>`
})
export class AppComponent {
    @ViewChild("spreadsheet") spreadsheet: ElementRef;
    // Worksheets
    worksheets: jspreadsheet.worksheetInstance[];

    // Create a new data grid
    ngAfterViewInit() {
        // Create spreadsheet
        this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
            worksheets: [{
                data: [
    [
        "Decimal",
        "Binary",
        "Binary (8 places)"
    ],
    [
        15,
        "=DEC2BIN(A2)",
        "=DEC2BIN(A2,8)"
    ],
    [
        42,
        "=DEC2BIN(A3)",
        "=DEC2BIN(A3,8)"
    ],
    [
        127,
        "=DEC2BIN(A4)",
        "=DEC2BIN(A4,8)"
    ],
    [
        255,
        "=DEC2BIN(A5)",
        "=DEC2BIN(A5,8)"
    ]
]
            }]
        });
    }
}

Edit this page on GitHub