Difference between revisions of "Manuals/calci/DEC2BIN"
Jump to navigation
Jump to search
Line 21: | Line 21: | ||
DEC2BIN(100) is 100100 | DEC2BIN(100) is 100100 | ||
− | + | == Examples == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
<div id="1SpaceContent" class="zcontent" align="left"> | <div id="1SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
− | | | + | | '''Decimal Input''' |
− | + | | class=" " | '''Binary Output''' | |
− | + | ||
− | | class=" " | | ||
− | |||
− | |||
|- class="odd" | |- class="odd" | ||
− | |||
| class="sshl_f" | 1010 | | class="sshl_f" | 1010 | ||
| class="sshl_f" | 1100100 | | class="sshl_f" | 1100100 | ||
− | + | ||
− | |||
|- class="even" | |- class="even" | ||
− | |||
− | |||
− | |||
− | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
+ | |||
|- class="odd" | |- class="odd" | ||
− | |||
− | |||
− | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
+ | |||
|- class="even" | |- class="even" | ||
− | |||
− | |||
− | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
+ | |||
|- class="odd" | |- class="odd" | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
|} | |} | ||
− | |||
− | |||
− |
Revision as of 06:36, 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 number is negative or nonnumeric.
- DEC2BIN returns the NAN(error) value, whenever the padding is nonnumeric, zero or negative.
Lets see an example,
DEC2BIN(10, 5) is 1010
DEC2BIN(100) is 100100
Examples
Decimal Input | Binary Output |
1010 | 1100100 |