BIN2OCT
Converts binary number to octal.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Text
Examples
=BIN2OCT(1001, 3) Result 011
Syntax
BIN2OCT(number, [places]) number- any required
places- number optional defaults to
1
Converts binary number to octal.
=BIN2OCT(1001, 3) BIN2OCT(number, [places]) numberplaces1