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 21: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 |