Difference between revisions of "Manuals/calci/BIN2OCT"

From ZCubes Wiki
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'''
| Column1
+
| class="  " | '''Hex Output'''
| class="  " | Column2
+
 
| Column3
 
| Column4
 
 
|- class="odd"
 
|- class="odd"
| class=" " | Row1
+
| class="sshl_f" | BIN2HEX(100)
| class="sshl_f" | 1100100
+
| class="sshl_f" | 4
| class="sshl_f" | 144
+
 
| class="sshl_f" |
 
| class="sshl_f" |
 
 
|- class="even"
 
|- class="even"
| class=" " | Row2
+
| class="ssh1_f" | BIN2HEX(110011,4)
| class="sshl_f" |
+
| class="sshl_f" | 0033
| class=" SelectTD SelectTD" |
+
 
<div id="2Space_Handle" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div>
 
|
 
|
 
 
|- class="odd"
 
|- class="odd"
| Row3
+
| class="ssh1_f" | BIN2HEX(11001100,6)
| class="                                       sshl_f                 " |
+
| class="sshl_f" | 0000CC
|
+
 
|
 
|
 
 
|- class="even"
 
|- class="even"
| Row4
+
| class="ssh1_f" | BIN2HEX(11110000)
|
+
| class="sshl_f" | F0
|
+
 
|
 
| class=" " |
 
|- class="odd"
 
| class=" " | Row5
 
|
 
|
 
|
 
|
 
|- class="even"
 
| Row6
 
|
 
|
 
|
 
|
 
 
|}
 
|}
  
<div align="left">[[Image:calci1.gif]]</div></div>
+
== 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

See Also

References