Engineering
BIN2OCT function
Binary to octal. BIN2OCT works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=BIN2OCT(number, [places]) | Argument | Use |
|---|---|
number | required |
places | optional |
On live data
In Sheets, BIN2OCT sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More engineering functions
BESSELIModified Bessel function In(x)BESSELJBessel function Jn(x)BESSELKModified Bessel function Kn(x)BESSELYBessel function Yn(x)BIN2DECBinary to decimalBIN2HEXBinary to hexadecimalBITANDBitwise AND of two numbersBITLSHIFTNumber shifted left by N bitsBITORBitwise OR of two numbersBITRSHIFTNumber shifted right by N bitsBITXORBitwise XOR of two numbersCOMPLEXComplex number from real and imaginary parts
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.