Difference between revisions of "Manuals/calci/DEC2HEX"
Jump to navigation
Jump to search
| Line 25: | Line 25: | ||
{| id="TABLE1" class="SpreadSheet blue" | {| id="TABLE1" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" | + | | class=" " | '''Function''' |
| − | + | | class=" " | '''HEX Output''' | |
| − | + | ||
| − | |||
| − | | class=" " | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | DEC2HEX(10) | |
| − | + | | class="sshl_f" | | |
| − | | class="sshl_f" | | + | |
| − | | class="sshl_f" | | ||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | DEC2HEX(10,4) | |
| − | + | | class="sshl_f" | | |
| − | | class="sshl_f" | | + | |
| − | | class="sshl_f" | | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | DEC2HEX(100,8) | |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | DEC2HEX(-56) | |
| − | | class="sshl_f" | | + | | class="sshl_f" | |
| − | | class="sshl_f" | | + | |
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class="sshl_f" | DEC2HEX(-512) | |
| − | + | | class="sshl_f" | | |
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f" | | ||
|} | |} | ||
| − | + | == See Also == | |
| − | + | ||
| + | *[[Manuals/calci/DEC2BIN| DEC2BIN]] | ||
| + | |||
| + | *[[Manuals/calci/DEC2OCT| DEC2OCT]] | ||
| + | |||
| + | *[[Manuals/calci/BIN2DEC| BIN2DEC]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Hexadecimal Hexadecimal Numbers] | ||
Revision as of 16:03, 16 November 2013
DEC2HEX(number, places)
- Where 'number' is the decimal integer to be converted and
- 'places' is the number of characters to be used to display the output.
DEC2HEX() converts a decimal number to its hexadecimal equivalent.
Description
DEC2HEX(number, places)
- If the number is nonnumeric or negative, Calci returns an #ERROR value.
- If 'places' is non-numeric or negative, Calci returns an #ERROR value.
For Example,
DEC2HEX(50, 5) returns 32
DEC2HEX(35) returns 23
Examples
| Function | HEX Output |
| DEC2HEX(10) | |
| DEC2HEX(10,4) | |
| DEC2HEX(100,8) | |
| DEC2HEX(-56) | |
| DEC2HEX(-512) |