Difference between revisions of "Manuals/calci/DEC2BIN"
Jump to navigation
Jump to search
| Line 34: | Line 34: | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | ''' | + | | '''Function''' |
| class=" " | '''Binary Output''' | | class=" " | '''Binary Output''' | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | 10 | + | | class="sshl_f" | DEC2BIN(10) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 0000001010 |
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | DEC2BIN(10,4) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 1010 |
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | DEC2BIN(100,8) |
| − | | class="sshl_f" | | + | | class="sshl_f" | 01100100 |
|- class="even" | |- class="even" | ||
| − | | class="sshl_f" | | + | | class="sshl_f" | DEC2BIN(-56) |
| class="sshl_f" | | | class="sshl_f" | | ||
Revision as of 16:21, 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)
- DEC2BIN returns the NAN(error) value, when the 'number' is negative or nonnumeric.
- The 'number' should be in the range -512 to 511.
- '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.
Lets see an example,
DEC2BIN(10, 5) is 1010
DEC2BIN(100) is 100100
Examples
| Function | Binary Output |
| DEC2BIN(10) | 0000001010 |
| DEC2BIN(10,4) | 1010 |
| DEC2BIN(100,8) | 01100100 |
| DEC2BIN(-56) | |