Difference between revisions of "Manuals/calci/HEX2BIN"
Jump to navigation
Jump to search
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=HEX2BIN(number, places)= | =HEX2BIN(number, places)= | ||
| − | *Where | + | *Where <math>number</math> is the hexadecimal number to be converted, and |
| − | * | + | *<math>places</math> is the number of characters to display the output. |
HEX2BIN() converts a hexadecimal number to its binary equivalent. | HEX2BIN() converts a hexadecimal number to its binary equivalent. | ||
| Line 9: | Line 9: | ||
HEX2BIN(number, places) | HEX2BIN(number, places) | ||
| − | + | For example, | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | HEX2BIN("1EE",9) ''returns 111101110 '' | |
| + | |||
| + | HEX2BIN("4F",4) ''returns 1001111'' | ||
| + | |||
| + | *The <math>number</math> can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error. | ||
| + | *Hexadecimal number uses numbers from 0 to 9 and characters from A to F. Hence, the number argument should be entered in quotes (e.g. "1FF"). | ||
| + | *The most significant bit of the number is the sign bit and remaining bits are magnitude bits. A negative number is represented in 2's complement form. | ||
| + | *Calci returns an #ERROR message, if the <math>number</math> is not a valid hexadecimal number. | ||
| + | *<math>places</math> argument is used to return the output with leading zeros. If <math>places</math> argument is not used, 'Calci' uses the minimum number of characters required to display the binary output. | ||
| + | *If <math>places</math> is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output. | ||
| + | *If <math>places</math> is not an integer, Calci rounds the value and uses the integer part as input. | ||
| + | *If <math>places</math> is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output. | ||
| − | + | == Examples == | |
| − | + | <div id="1SpaceContent" class="zcontent" align="left"> | |
| − | + | {| id="TABLE1" class="SpreadSheet blue" | |
| + | |- class="even" | ||
| + | | class=" " | '''Function''' | ||
| + | | class=" " | '''Binary Output''' | ||
| + | |- class="odd" | ||
| + | | class="sshl_f" | HEX2BIN("A",5) | ||
| + | | class="sshl_f" | 01010 | ||
| − | + | |- class="even" | |
| − | + | | class="sshl_f" | HEX2BIN("10",8) | |
| − | + | | class="sshl_f" | 00010000 | |
| − | |||
| − | |||
| − | + | |- class="odd" | |
| − | - | + | | class="sshl_f" | HEX2BIN("FFFFFFFE00") |
| − | + | | class="sshl_f" | 1000000000 | |
| − | HEX2BIN | + | |- class="even" |
| + | | class="sshl_f" | HEX2BIN("0FF",-5) | ||
| + | | class="sshl_f" | 11111111 | ||
| − | + | |- class="odd" | |
| + | | class="sshl_f" | HEX2BIN("DF") | ||
| + | | class="sshl_f" | 0011011111 | ||
| − | + | |- class="even" | |
| − | - | + | | class="sshl_f" | HEX2BIN("C",6.3) |
| − | + | | class="sshl_f" | 0001100 | |
| − | + | |} | |
| − | + | ==Related Videos== | |
| − | HEX2BIN | + | {{#ev:youtube|7yfNWmHR0GE|280|center|HEX2BIN}} |
| − | + | == See Also == | |
| − | + | *[[Manuals/calci/HEX2DEC| HEX2DEC]] | |
| − | + | *[[Manuals/calci/HEX2OCT| HEX2OCT]] | |
| − | + | *[[Manuals/calci/BIN2HEX| BIN2HEX]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | *[http://en.wikipedia.org/wiki/Hexadecimal#Conversion Hexadecimal to Binary Conversion] | |
| − | |||
Latest revision as of 15:47, 17 April 2015
HEX2BIN(number, places)
- Where is the hexadecimal number to be converted, and
- is the number of characters to display the output.
is the hexadecimal number to be converted, and
is the number of characters to display the output.HEX2BIN() converts a hexadecimal number to its binary equivalent.
Description
HEX2BIN(number, places)
For example,
HEX2BIN("1EE",9) returns 111101110
HEX2BIN("4F",4) returns 1001111
- The can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
- Hexadecimal number uses numbers from 0 to 9 and characters from A to F. Hence, the number argument should be entered in quotes (e.g. "1FF").
- The most significant bit of the number is the sign bit and remaining bits are magnitude bits. A negative number is represented in 2's complement form.
- Calci returns an #ERROR message, if the is not a valid hexadecimal number.
- argument is used to return the output with leading zeros. If argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
- If is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output.
- If is not an integer, Calci rounds the value and uses the integer part as input.
- If is less than the number of output characters, Calci ignores the places and uses the minimum number of characters required to display the output.
Examples
| Function | Binary Output |
| HEX2BIN("A",5) | 01010 |
| HEX2BIN("10",8) | 00010000 |
| HEX2BIN("FFFFFFFE00") | 1000000000 |
| HEX2BIN("0FF",-5) | 11111111 |
| HEX2BIN("DF") | 0011011111 |
| HEX2BIN("C",6.3) | 0001100 |