writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 13:
Line 13: − + Line 23:
Line 23: + + − HEX2BIN() ''returns 011110'' + + + + + + + − *If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.+ − *If the NumberPlaces is a negative, it returns the #ERROR.+ − *If NumberPlaces > LengthofSomeNumber then returns #ERROR.+ − *If number is not valid hexadecimal number, it returns #ERROR. − *If NumberPlaces > 10 ,then it returns #ERROR. − </div>+ − + − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">+ − + + + − <font size="6"></font>+ + + + − </div></div>+ − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − Lets see an example in (Column1, Row1)+ − <nowiki>=HEX2BIN("A",5)</nowiki>+ − HEX2BIN converts A to 01010.+ − Consider an another example(Column1,Row2)+ − − <nowiki>=HEX2BIN("C3")</nowiki> − − Converts C3 to 11000011. − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f" | 1010 − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 11000011 − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | Row3 − | class=" SelectTD ChangeBGColor SelectTD" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row4 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="odd" − | class=" " | Row5 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |- class="even" − | Row6 − | class=" " | − | class=" " | − | class=" " | − | class=" " | − |} − <div align="left">[[Image:calci1.gif]]</div></div>+ − ----
no edit summary
HEX2BIN("1EE",9) ''returns 111101110 ''
HEX2BIN("1EE",9) ''returns 111101110 ''
HEX2BIN("4F,4) ''returns 1001111''
HEX2BIN("4F",4) ''returns 1001111''
*The 'number' can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
*The 'number' can be maximum of 10 characters (40 bits). If it exceeds the limit, Calci gives a #NUM! error.
*If 'places' is not an integer, Calci rounds the value and uses the integer part as input.
*If 'places' is not an integer, Calci rounds the value and uses the integer part as input.
== Examples ==
<div id="1SpaceContent" class="zcontent" align="left">
{| id="TABLE1" class="SpreadSheet blue"
|- class="even"
| class=" " | '''Function'''
| class=" " | '''Binary Output'''
|- class="odd"
| class="sshl_f" | HEX2BIN("A",5)
| class="sshl_f" |
|- class="even"
| class="sshl_f" | HEX2BIN("10",8)
| class="sshl_f" |
|- class="odd"
----
| class="sshl_f" | HEX2BIN("FFFFF00",7)
| class="sshl_f" |
HEX2BIN
|- class="even"
| class="sshl_f" | HEX2BIN("FF0FF0",-5)
| class="sshl_f" |
|- class="odd"
| class="sshl_f" | HEX2BIN()
| class="sshl_f" |
|}
== See Also ==
*[[Manuals/calci/DEC2HEX| DEC2HEX]]
*[[Manuals/calci/DEC2OCT| DEC2OCT]]
*[[Manuals/calci/BIN2DEC| BIN2DEC]]
==References==
*[http://en.wikipedia.org/wiki/Decimal Decimal Numbers]