Difference between revisions of "Manuals/calci/DEC2BIN"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
DEC2BIN(number, padding) | DEC2BIN(number, padding) | ||
| + | |||
| + | *The 'number' should be in the range -512 to 511. | ||
*DEC2BIN returns the NAN(error) value, when the 'number' is negative or nonnumeric. | *DEC2BIN returns the NAN(error) value, when the 'number' is negative or nonnumeric. | ||
| − | |||
| − | |||
*'padding' argument is used to return the output with leading zeros. If 'padding' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output. | *'padding' argument is used to return the output with leading zeros. If 'padding' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output. | ||
| Line 23: | Line 23: | ||
*If 'padding' contains decimal value, Calci truncates the decimal point and uses the integer value as input. | *If 'padding' contains decimal value, Calci truncates the decimal point and uses the integer value as input. | ||
| − | + | For example, | |
| + | |||
| + | DEC2BIN(10, 4) ''returns 1010'' | ||
| − | DEC2BIN( | + | DEC2BIN(100) ''returns 0001100100'' |
| − | DEC2BIN( | + | DEC2BIN(30,5.5) ''returns 011110'' |
== Examples == | == Examples == | ||
Revision as of 16:46, 14 November 2013
DEC2BIN(number, padding)
- Where 'number' is the decimal integer to be converted and
- 'padding' is the number of characters to display the output.
DEC2BIN() function converts a decimal number to its binary equivalent.
Description
DEC2BIN(number, padding)
- The 'number' should be in the range -512 to 511.
- DEC2BIN returns the NAN(error) value, when the 'number' is negative or nonnumeric.
- 'padding' argument is used to return the output with leading zeros. If 'padding' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
- DEC2BIN returns the NAN(error) value, whenever the 'padding' is nonnumeric, zero or negative.
- If 'padding' contains decimal value, Calci truncates the decimal point and uses the integer value as input.
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 |