Manuals/calci/HEX2OCT
Jump to navigation
Jump to search
HEX2OCT(SomeNumber, NumberPlaces)
where,
SomeNumber - is the hexadecimal number.
NumberPlaces - is the number of characters.If omitted then it use minimum number of characters.NumberPlace is use for adding to return value with leading zeros.
Calci converts a hexadecimal number to octal.
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 NaN.
HEX2OCT
Lets see an example in (Column1, Row1)
=HEX2OCT("A",4)
HEX2OCT converts A to 0012 upto 4 charcacters.
Consider an another example(Column1, Row2)
=HEX2OCT("2BEA")
It converts into 25752.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 12 | |||
| Row2 | 25752 | |||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
