Difference between revisions of "Manuals/calci/BIN2OCT"
Jump to navigation
Jump to search
| Line 28: | Line 28: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Formula''' |
| − | + | | class=" " | '''Hex Output''' | |
| − | | class=" " | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | BIN2HEX(100) | |
| − | + | | class="sshl_f" | 4 | |
| − | | class="sshl_f" | | + | |
| − | | class="sshl_f" | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="ssh1_f" | BIN2HEX(110011,4) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0033 |
| − | + | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | | class="ssh1_f" | BIN2HEX(11001100,6) |
| − | | class=" | + | | class="sshl_f" | 0000CC |
| − | + | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="ssh1_f" | BIN2HEX(11110000) | |
| − | + | | class="sshl_f" | F0 | |
| − | + | ||
| − | |||
| − | | class=" | ||
| − | | | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/BIN2DEC| BIN2DEC]] | ||
| + | |||
| + | *[[Manuals/calci/BIN2OCT| BIN2OCT]] | ||
| + | |||
| + | *[[Manuals/calci/HEX2BIN| HEX2BIN]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Binary_number#Hexadecimal Conversion to Hexadecimal Number] | ||
Revision as of 22:13, 15 November 2013
BIN2OCT(number,places)
- Where 'number' is a binary number to be converted and
- 'places' is the number of characters to be used to display the output.
BIN2OCT converts a binary number to its octal equivalent.
Description
BIN2OCT(number,places)
- 'number' must be a binary number.
- Calci returns an #ERROR message if 'number' contains more than 10 characters (10 bits).
- If 'number' is negative, BIN2HEX shows an #ERROR message.
- If 'places' is not an integer, it is truncated.
- Calci returns an #ERROR message if 'places' are nonnumeric or negative.
BIN2OCT(1100100) returns 144
Examples
| Formula | Hex Output |
| BIN2HEX(100) | 4 |
| BIN2HEX(110011,4) | 0033 |
| BIN2HEX(11001100,6) | 0000CC |
| BIN2HEX(11110000) | F0 |