OCT2BIN

Formulas / OCT2BIN
Convert an octal number into a binary number.
==OCT2BIN(number,[places])
  • Number - The octal number to convert to binary
  • Places [OPTIONAL] - The number of characters in the returned binary number

Examples

  • =OCT2BIN( "5" )

    The formula converts the octal number 5 to a binary number. The result is 101, as 5 in octal is equivalent to 5 in binary.

  • =OCT2BIN( "0000000001" )

    The formula converts the octal number 01 to a binary number. The result is 1, as 01 in octal is equivalent to 1 in binary.

  • =OCT2BIN( "2", 10 )

    The formula converts the octal number 2 to a binary number with 10 places. The result is 0001000000, as 2 in octal is equivalent to 32 in binary, which is 10 places when padded with 0s.

  • =OCT2BIN( "7777777770" )

    The formula converts the octal number 7777777770 to a binary number with 10 places. The result is 1111111110, as 7777777770 in octal is equivalent to 4294967294 in binary, which is 10 places when padded with 0s.

  • =OCT2BIN( "16" )

    The formula converts the octal number 16 to a binary number with 10 places. The result is 0100000000, as 16 in octal is equivalent to 512 in binary, which is 10 places when padded with 0s.


Summary

The OCT2BIN function in Sourcetable converts an Octal number into a binary number. The number argument is required, and the places argument is optional.

  • The OCT2BIN function converts an Octal number into a binary number.
  • The arguments for the OCT2BIN function are number (required) and places (optional).
  • The OCT2BIN function returns a binary number that is at least as many places as specified by the places argument.

Frequently Asked Questions

What is the OCT2BIN function?
The OCT2BIN function is a Sourcetable function that converts an octal number to a binary number.
What are the arguments for the OCT2BIN function?
The OCT2BIN function takes two arguments:
  • Number (required)
  • Places (optional)
What does the OCT2BIN function return?
The OCT2BIN function returns a 10-character binary number if the number is negative. If the places argument is negative, then the function will return a #NUM! error.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV