Difference between revisions of "Manuals/calci/BIN2OCT"
Jump to navigation
Jump to search
| (7 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
BIN2OCT(number,places) | BIN2OCT(number,places) | ||
| − | *'number' must be a binary number. | + | *'number' must be a binary number. Binary number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101"). |
| − | * | + | *The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation. |
| − | *If 'number' is negative, | + | *A number preceding with '0' (e.g 0111111111) should be written in text format ("0111111111") to avoid confusion with octal numbers. |
| + | |||
| + | *Calci returns an #ERROR message if 'number' contains more than 10 characters (10 bits). | ||
| + | |||
| + | *If 'number' is negative, Calci ignores the places, if any and displays the octal output. | ||
*If 'places' is not an integer, it is truncated. | *If 'places' is not an integer, it is truncated. | ||
| − | *Calci returns an #ERROR message | + | *If 'places' are nonnumeric, Calci returns an #ERROR message. |
| + | |||
| + | *If 'places' is negative, Calci ignores the places and displays the octal output. | ||
| + | |||
| + | For Example, | ||
BIN2OCT(1100100) ''returns 144'' | BIN2OCT(1100100) ''returns 144'' | ||
| + | |||
| + | BIN2OCT(100100100,4) ''returns 0444'' | ||
| + | |||
| + | BIN2OCT("00111",1.3) ''returns 07'' | ||
== Examples == | == Examples == | ||
| Line 28: | Line 40: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | '''Formula''' |
| − | + | | class=" " | '''Octal Output''' | |
| − | | class=" " | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | BIN2OCT(100) | |
| − | + | | class="sshl_f" | 4 | |
| − | | class="sshl_f" | | + | |
| − | | class="sshl_f" | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class="ssh1_f" | BIN2OCT(110011,4) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0063 |
| − | + | ||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | | + | | class="ssh1_f" | BIN2OCT(11001100,6) |
| − | | class=" | + | | class="sshl_f" | 000314 |
| − | + | ||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="ssh1_f" | BIN2OCT(111111111) | |
| − | + | | class="sshl_f" | 777 | |
| − | + | ||
| − | |||
| − | | class=" | ||
| − | | | ||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | + | ==Related Videos== | |
| − | + | ||
| + | {{#ev:youtube|FDuofN1MX0Y|280|center|BIN2OCT}} | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/BIN2DEC| BIN2DEC]] | ||
| + | |||
| + | *[[Manuals/calci/BIN2HEX| BIN2HEX]] | ||
| + | |||
| + | *[[Manuals/calci/OCT2BIN| OCT2BIN]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Binary_number#Octal Conversion to Octal Number] | ||
Latest revision as of 16:07, 18 April 2015
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. Binary number is represented using digits 1 or 0 only. The number can also be entered in text format (e.g "101").
- The most significant bit represents the 'sign' of the number (0=positive, 1=negative). Negative numbers are represented using 2's complement notation.
- A number preceding with '0' (e.g 0111111111) should be written in text format ("0111111111") to avoid confusion with octal numbers.
- Calci returns an #ERROR message if 'number' contains more than 10 characters (10 bits).
- If 'number' is negative, Calci ignores the places, if any and displays the octal output.
- If 'places' is not an integer, it is truncated.
- If 'places' are nonnumeric, Calci returns an #ERROR message.
- If 'places' is negative, Calci ignores the places and displays the octal output.
For Example,
BIN2OCT(1100100) returns 144
BIN2OCT(100100100,4) returns 0444
BIN2OCT("00111",1.3) returns 07
Examples
| Formula | Octal Output |
| BIN2OCT(100) | 4 |
| BIN2OCT(110011,4) | 0063 |
| BIN2OCT(11001100,6) | 000314 |
| BIN2OCT(111111111) | 777 |