You can convert octal numbers into decimal numbers Octal numbers contain 0 to 7 values OCT2DEC Function has a limit of 777 octal numbers If you write more than 777 characters it will return #NUM error Syntax of OCT2DEC Function =OCT2DEC(number) Argument of OCT2DEC Function Number: it is the number you want to convert into octal Behavior of OCT2DEC Function Here we have taken an example of the octal number and convert it...

You can convert octal numbers into binary numbers The binary numbers contain only 0 and 1 values Octal numbers contain 0 to 7 values OCT2BIN Function has a limit of 777 octal numbers If you write more than 777 characters it will return #NUM error Syntax of OCT2BIN Function =OCT2BIN(number,[places]) Argument of OCT2BIN Function Number: it is the number you want to convert into octal Places:[Optional] how many characters you want to show...

You can convert octal numbers into hexadecimal numbers The hexadecimal numbers contain only 0 and F values Octal numbers contain 0 to 7 values OCT2HEX Function has a limit of 777 octal numbers If you write more than 777 characters it will return #NUM error Syntax of OCT2HEX Function =OCT2HEX(number,[places]) Argument of OCT2HEX Function Number: it is the number you want to convert into hexadecimal Places:[Optional] how many characters...

You can convert binary number to a decimal number. The binary number contains only 0 and 1 values. Decimal pattern is 8 4 2 1. It has a limit of 10 characters If you write 10 times 1 it will return -1 Syntax =BIN2DEC(number) Arguments Number: The binary number(reference) which you want to convert in to decimal. Behavior Here we have taken an example of binary numbers from"000" to "111" which gives result in decimal numbers A...

You can convert Decimal numbers into binary numbers The binary numbers contain only 0 and 1 values DEC2BIN Function has a limit of 511 Decimal numbers If you write more than 511 characters it will return #NUM error Syntax =DEC2BIN(number,[places]) Argument Number: it is the number you want to convert into binary Places:[Optional] how many characters you want to show in your result. It will place "0" before the result. Behavior Here...

You can convert decimal numbers into octal numbers Octal numbers contain 0 to 7 values DEC2OCT Function has a limit of eight times "9" If you write nine times "9" characters it will return #NUM error Syntax =DEC2OCT(number,[place]) Argument Number: it is the number you want to convert into octal Places:[Optional] how many characters you want to show in your result. It will place "0" before the result. Behavior Here we have...

You can convert binary numbers into hexadecimal numbers The binary numbers contain only 0 and 1 values Oct numbers contain 0 to 15 values BIN2HEX Function has a limit of 10 characters If you write more than 10 characters it will return #NUM error Syntax =BIN2HEX(number,[places]) Argument Number: it is the number you want to convert into octal Places:[Optional] how many characters you want to show in your result. It...

You can convert hexadecimal numbers into binary numbers The binary numbers contain only 0 and 1 values Hexadecimal numbers contain 0 to 15 values HEX2BIN Function has a limit of 10 characters(1FF in HEX) in binary numbers If you write more than 10 characters(More then 1FF) it will return #NUM error Syntax =HEX2BIN(number,[places]) Argument Number: it is the number you want to convert into binary Places:[Optional] how...

You can convert Hexadecimal numbers into decimal numbers The hexadecimal numbers contain only 0 and F values HEX2DEC Function has a limit of nine times "f" decimal numbers If you write more than ten times "F" characters it will return"-1" If you write more than ten times"F" it will return #NUM error Syntax =DEC2HEX(number) Argument Number: it is the number you want to convert into hexadecimal Behavior Here we have taken...

You can convert hexadecimal numbers into octal numbers The hexadecimal numbers contain only 0 and F values Octal numbers contain 0 to 7 values OCT2HEX Function has a limit of ten times of "F" hexadecimal numbers If you write more than ten times "F" characters it will return #NUM error Syntax =HEX2OCT(number) Argument Number: it is the number you want to convert into octal numbers Behavior Here we have taken an example of the hexadecimal...

You can convert decimal numbers into hexadecimal numbers The hexadecimal numbers contain only 0 and F values DEC2HEX Function has a limit of eleven times "9" decimal numbers If you write more than eleven times "9" characters it will return #NUM error Syntax =DEC2HEX(number,[places]) Argument Number: it is the number you want to convert into hexadecimal Places:[Optional] how many characters you want to show in your result. It will place "0"...

CONVERT Function will convert measurements between two units. If you want to convert the area from Hectare to Acre, weights from Pounds to Kilograms, temperature from Ferenhite to Celsius etc. Syntax of CONVERT Function =CONVERT(number,from_unit,to_unit) Arguments of CONVERT Function number: It is the value which you want to convert from_unit: The value unit which you have to_unit: The resultant unit value  Behavior of CONVERT Function Here...