HEX2BIN

Definition: HEX2BIN is a function that converts a hexadecimal number to binary.

Syntax: =HEX2BIN(number, [places])

Situation: This formula is suitable when you need to convert a hexadecimal number to binary.

Example: If you have a hexadecimal number “F”, the binary conversion can be found using the formula =HEX2BIN(“F”), which returns 1111.