writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − + + − where,+ − '''SomeNumber''' - is the hexadecimal number.+ + − + + + + + − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − Calci converts a hexadecimal number to binary number.+ − </div>+ − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.+ − If the NumberPlaces is a negative, it returns the #ERROR. − + − + − + − + − +
no edit summary
=HEX2BIN(number, places)=
'''HEX2BIN'''(SomeNumber, NumberPlaces)
*Where 'number' is the hexadecimal number to be converted, and
*'places' is the number of characters to display the output.If omitted then it use minimum number of characters.NumberPlaces is use for adding the return value with leading zero.
HEX2BIN() converts a hexadecimal number to its binary equivalent.
== Description ==
HEX2BIN(number, places)
'''NumberPlaces''' - is the number of characters.If omitted then it use minimum number of characters.NumberPlaces is use for adding the return value with leading zero.
*The 'number' should be in the range to . If it exceeds the limit, Calci gives a #NUM! error.
*Calci returns an #ERROR message, if the 'number' is not a valid hexadecimal number.
*'places' argument is used to return the output with leading zeros. If 'places' argument is not used, 'Calci' uses the minimum number of characters required to display the binary output.
*If 'places' is negative, Calci returns an error message.
*If 'places' is not an integer, Calci truncates the value and uses the integer part as input.
For example,
HEX2BIN() ''returns 1010''
HEX2BIN() ''returns 0001100100''
HEX2BIN() ''returns 011110''
If NumberPlaces > LengthofSomeNumber then returns #ERROR.
*If SomeNumber and NumberPlaces are non-numeric, HEX2BIN returns the#ERROR.
*If the NumberPlaces is a negative, it returns the #ERROR.
If number is not valid hexadecimal number, it returns #ERROR.
*If NumberPlaces > LengthofSomeNumber then returns #ERROR.
*If number is not valid hexadecimal number, it returns #ERROR.
If NumberPlaces > 10 ,then it returns #ERROR.
*If NumberPlaces > 10 ,then it returns #ERROR.
</div>
</div>