BASE

Definition: BASE is a function that converts a number from one base to another.

Syntax: =BASE(number, from_base, [to_base])

Situation: This formula is suitable when you need to convert a number from one base to another, such as from binary to decimal or hexadecimal to octal.

Example: If you have a binary number 1010, the decimal equivalent can be found using the formula =BASE(1010, 2, 10), which returns 10. Similarly, if you have a hexadecimal number A3, the octal equivalent can be found using the formula =BASE(“A3”, 16, 8), which returns 243.