| Line 1: |
Line 1: |
| | =OCT2HEX(number, places)= | | =OCT2HEX(number, places)= |
| | | | |
| − | *Where 'number' is an octal number to be converted and | + | *Where <math>number</math> is an octal number to be converted and |
| − | *'places' is the number of characters to be used to display the output. | + | *<math>places</math> is the number of characters to be used to display the output. |
| | | | |
| | OCT2HEX() converts an octal number to its hexadecimal equivalent. | | OCT2HEX() converts an octal number to its hexadecimal equivalent. |
| Line 17: |
Line 17: |
| | OCT2HEX(777,3) ''returns 1FF'' | | OCT2HEX(777,3) ''returns 1FF'' |
| | | | |
| − | *The 'number' can be upto 9 digits. The most significant bit is the sign bit and remaining bits are magnitude bits. | + | *The <math>number</math> can be upto 9 digits. The most significant bit is the sign bit and remaining bits are magnitude bits. |
| − | *If 'number' is negative, Calci ignores the places and returns a 7 digit hexadecimal number. | + | *If <math>number</math> is negative, Calci ignores the places and returns a 7 digit hexadecimal number. |
| | <font color=blue> Need to check the input and output limits after next release</font> | | <font color=blue> Need to check the input and output limits after next release</font> |
| − | *If the 'number' is not an integer, Calci displays an #NUM! error message. | + | *If the <math>number</math> is not an integer, Calci displays an #NUM! error message. |
| − | *If the 'number' is an invalid octal number, Calci displays an #NUM! error message. | + | *If the <math>number</math> is an invalid octal number, Calci displays an #NUM! error message. |
| − | *'places' argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary. | + | *<math>places</math> argument can be omitted. Calci displays the hexadecimal output with minimum number of characters necessary. |
| − | *'places' is used for padding the output with leading '0's'. | + | *<math>places</math> is used for padding the output with leading '0's'. |
| − | *Calci ignores the 'places', if the output is more than mentioned 'places'. | + | *Calci ignores the <math>places</math>, if the output is more than mentioned 'places'. |
| − | *If the 'places' is non-numeric or negative, Calci displays an error message. | + | *If the <math>places</math> is non-numeric or negative, Calci displays an error message. |
| − | *If 'places' is not an integer, Calci truncates the 'places' value. | + | *If <math>places</math> is not an integer, Calci truncates the 'places' value. |
| | *A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with hexadecimal numbers. | | *A number preceding with '0' (e.g. 0377) should be written in text format ("0377") to avoid confusion with hexadecimal numbers. |
| | | | |