Difference between revisions of "Manuals/calci/HEX2BIN"
Jump to navigation
Jump to search
| (6 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 15: | Line 15: | ||
HEX2BIN("4F",4) ''returns 1001111'' | HEX2BIN("4F",4) ''returns 1001111'' | ||
| − | *The | + | *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"). | *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. | *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 | + | *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 | + | *If <math>places</math> is negative, Calci ignores the places and uses the minimum number of characters required to display the binary output. |
| − | *If | + | *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 == | == Examples == | ||
| Line 38: | Line 39: | ||
|- class="even" | |- class="even" | ||
| class="sshl_f" | HEX2BIN("10",8) | | class="sshl_f" | HEX2BIN("10",8) | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | 00010000 |
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | HEX2BIN(" | + | | class="sshl_f" | HEX2BIN("FFFFFFFE00") |
| − | | class="sshl_f" | | + | | class="sshl_f" | 1000000000 |
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | HEX2BIN(" | + | | class="sshl_f" | HEX2BIN("0FF",-5) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 11111111 |
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | HEX2BIN() | + | | class="sshl_f" | HEX2BIN("DF") |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0011011111 |
| + | |||
| + | |- class="even" | ||
| + | | class="sshl_f" | HEX2BIN("C",6.3) | ||
| + | | class="sshl_f" | 0001100 | ||
| + | |||
|} | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|7yfNWmHR0GE|280|center|HEX2BIN}} | ||
== See Also == | == See Also == | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/HEX2DEC| HEX2DEC]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/HEX2OCT| HEX2OCT]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/BIN2HEX| BIN2HEX]] |
==References== | ==References== | ||
| − | *[http://en.wikipedia.org/wiki/ | + | *[http://en.wikipedia.org/wiki/Hexadecimal#Conversion Hexadecimal to Binary Conversion] |
Latest revision as of 14: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 |