# Documentation/Calc Functions/DEC2BIN

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

DEC2BIN

## Category:

Add-in

## Summary:

Converts a decimal number (base-10) to its binary (base-2) equivalent. The input decimal number must be in the range -512 ≤ *d* < +511.

## Syntax:

DEC2BIN(**Number**[; **Places**])

## Returns:

Returns a text string comprising up to 10 binary digits (0 or 1), which is the binary number in two’s complement form that corresponds to the specified decimal number.

## Arguments:

**Number** is a string or a number, or a reference to a cell containing one of those types, which gives the decimal number that is to be converted to binary. **Number** should be an integer value that is not less than -512 or greater than +511.

**Places** is an integer in the range 1 to 10, or a reference to a cell containing that value, which is the number of binary characters that should be returned for a positive **Number**. **Places** is ignored for negative values of **Number**, when DEC2BIN always returns 10 binary characters. The default for positive values of **Number** is for the returned string to occupy as many characters as necessary to accommodate the binary representation; however, you can set the value of **Places** to add leading zeroes where necessary.

- If
**Number**is non-numeric (including an empty string), then DEC2BIN reports a #VALUE! error. - If
**Number**is a non-integer value, then DEC2BIN truncates it to an integer. - If, after any truncation,
**Number**is outside the range specified, DEC2BIN reports an invalid argument error (Err:502). - If
**Number**is a reference to an empty cell, DEC2BIN returns 0 (possibly with leading zeroes, depending on the value of**Places**). - If
**Places**is non-numeric, then DEC2BIN reports an invalid argument error (Err:502). - If
**Places**is a non-integer value, then DEC2BIN truncates it to an integer. - If, after any truncation,
**Places**is less than 1 or greater than 10, DEC2BIN reports an invalid argument error (Err:502). - If
**Number**is positive and**Places**is less than the minimum number of characters required to accommodate the binary representation of**Number**, then DEC2BIN reports an invalid argument error (Err:502).

## Additional details:

The following Wikipedia pages provide useful background information relevant to this function:

## Examples:

Formula | Description | Returns |
---|---|---|

=DEC2BIN(63) | Here the function converts the decimal value of 63 (passed as a number) to its binary equivalent of 111111. | 111111 |

=DEC2BIN("63"; 8) | Here the function again converts the decimal value of 63 (passed as a string) to its binary equivalent of 111111 but also adds two leading zeroes. | 00111111 |

=DEC2BIN(D1; D2) where cells D1 and D2 contain the numbers 63 and 10 respectively. | Here the function again converts the decimal value of 63 (passed via a cell reference on this occasion) to its binary equivalent of 111111 but also adds four leading zeroes. | 0000111111 |

=DEC2BIN(-512) | Here the function converts the minimum allowed decimal value of -512 to its binary equivalent of 1000000000. | 1000000000 |

=DEC2BIN(-1) | Here the function converts the decimal value of -1 to its binary equivalent of 1111111111. | 1111111111 |

=DEC2BIN(+511) | Here the function converts the maximum allowed decimal value of +511 to its binary equivalent of 111111111. | 111111111 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

DEC2BIN