Converts a decimal number to binary.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
DEC2BIN(number, [places])The DEC2BIN function takes a decimal integer and returns its binary equivalent as a text string. If the number is negative, the function returns a 10-character two's complement binary number.
=DEC2BIN(10)Результат: 1010
Converts the decimal number 10 to its binary representation.
=DEC2BIN(5, 8)Результат: 00000101
Converts 5 to binary with a fixed length of 8 characters.
The function supports decimal integers from -512 to 511.