Difference between revisions of "Manuals/calci/DEC2BIN"
Jump to navigation
Jump to search
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =DEC2BIN(number, | + | =DEC2BIN(number, places)= |
*Where 'number' is the decimal integer to be converted and | *Where 'number' is the decimal integer to be converted and | ||
| − | *' | + | *'places' is the number of characters to display the output. |
DEC2BIN() function converts a decimal number to its binary equivalent. | DEC2BIN() function converts a decimal number to its binary equivalent. | ||
| Line 9: | Line 9: | ||
== Description == | == Description == | ||
| − | DEC2BIN(number, | + | DEC2BIN(number, places) |
| − | *The 'number' should be in the range -512 to 511. | + | *The 'number' should be in the range -512 to 511. If it exceeds the limit, Calci gives a #NUM! error. |
| − | *DEC2BIN returns | + | *DEC2BIN returns an #ERROR, when the 'number' is nonnumeric. |
| − | *' | + | *'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output. |
| − | * | + | *If 'places' is negative, Calci ignores the places and displays a 10 bit binary output. Most significant bit is the sign bit and remaining are magnitude bits. |
| − | *If ' | + | *If 'places' is not an integer, Calci truncates the value and uses the integer part as input. |
| + | |||
| + | *A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers. | ||
For example, | For example, | ||
| Line 34: | Line 36: | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | '''Function''' | + | | class=" " | '''Function''' |
| class=" " | '''Binary Output''' | | class=" " | '''Binary Output''' | ||
| Line 57: | Line 59: | ||
| class="sshl_f" | 1000000000 | | class="sshl_f" | 1000000000 | ||
|} | |} | ||
| + | |||
| + | ===ZOS Examples=== | ||
| + | DEC2BIN(0..10) | ||
| + | |||
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! number !! DEC2BIN | ||
| + | |- | ||
| + | | 0 || 0000000000 | ||
| + | |- | ||
| + | | 1 || 0000000001 | ||
| + | |- | ||
| + | | 2 || 0000000010 | ||
| + | |- | ||
| + | | 3 || 0000000011 | ||
| + | |- | ||
| + | | 4 || 0000000100 | ||
| + | |- | ||
| + | | 5 || 0000000101 | ||
| + | |- | ||
| + | | 6 || 0000000110 | ||
| + | |- | ||
| + | | 7 || 0000000111 | ||
| + | |- | ||
| + | | 8 || 0000001000 | ||
| + | |- | ||
| + | | 9 || 0000001001 | ||
| + | |- | ||
| + | | 10 || 0000001010 | ||
| + | |} | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|H4BstqvgBow|280|center|DEC2BIN}} | ||
== See Also == | == See Also == | ||
Latest revision as of 11:45, 22 April 2015
DEC2BIN(number, places)
- Where 'number' is the decimal integer to be converted and
- 'places' is the number of characters to display the output.
DEC2BIN() function converts a decimal number to its binary equivalent.
Description
DEC2BIN(number, places)
- The 'number' should be in the range -512 to 511. If it exceeds the limit, Calci gives a #NUM! error.
- DEC2BIN returns an #ERROR, when the 'number' is nonnumeric.
- 'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
- If 'places' is negative, Calci ignores the places and displays a 10 bit binary output. Most significant bit is the sign bit and remaining are magnitude bits.
- If 'places' is not an integer, Calci truncates the value and uses the integer part as input.
- A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with octal numbers.
For example,
DEC2BIN(10, 4) returns 1010
DEC2BIN(100) returns 0001100100
DEC2BIN(30,5.5) returns 011110
Examples
| Function | Binary Output |
| DEC2BIN(10) | 0000001010 |
| DEC2BIN(10,4) | 1010 |
| DEC2BIN(100,8) | 01100100 |
| DEC2BIN(-56) | 1111001000 |
| DEC2BIN(-512) | 1000000000 |
ZOS Examples
DEC2BIN(0..10)
| number | DEC2BIN |
|---|---|
| 0 | 0000000000 |
| 1 | 0000000001 |
| 2 | 0000000010 |
| 3 | 0000000011 |
| 4 | 0000000100 |
| 5 | 0000000101 |
| 6 | 0000000110 |
| 7 | 0000000111 |
| 8 | 0000001000 |
| 9 | 0000001001 |
| 10 | 0000001010 |