How to Use the BIN2OCT Function

The BIN2OCT function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number 2.2. What...

top of page

How to Use the BIN2OCT Function

The BIN2OCT function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number 2.2. What...

How to Use the OCT2BIN Function

The OCT2BIN function converts octal numbers into binary form. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2. What...

How to Use the OCT2DEC Function

The OCT2DEC function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is an Octal Number 2.2....

How to Use the DEC2OCT Function

The DEC2OCT function converts decimal numbers into octal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....

How to use the HEX2DEC Function

The HEX2DEC function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...

How to Use the DEC2HEX Function

The DEC2HEX function converts decimal numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number...

How to Use the HEX2BIN Function

The HEX2BIN function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Hexadecimal...

How to Use the BIN2HEX Function

The BIN2HEX function converts binary numbers into hexadecimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Binary Number...

How to Convert Large Decimal Numbers to Binary

There are lots of ways to convert decimal numbers into binary. Excel has a built in function for small numbers, but you'll need a custom...

How to Use the DEC2BIN Function

The DEC2BIN function converts decimal numbers into binary numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....

How to Convert Large Binary Numbers to Decimal in Excel

There are two good ways of converting binary to decimal. Excel has a built in function for small numbers, but you'll need a custom...

How to Use the BIN2DEC Function

The BIN2DEC function converts binary numbers into decimal numbers. Contents: 1. Syntax 2. Explanation 2.1. What is a Decimal Number 2.2....

How to Use the SQRT Function

The SQRT function returns the square root of any given number. Contents: 1. Syntax 2. Function Explanation 2.1. What is a Square Root 3....

How to use the LOG Function

The LOG function will calculate the logarithm of any given number to a specified base. Contents: 1. Syntax 2. Explanation 3. Examples...

How to use the LN Function

The LN function will calculate the natural logarithm of any given number. Contents: 1. Syntax 2. Explanation 3. Examples 3.1. Calculating...

How to use the GCD Function

The GCD function finds and returns the greatest common divisor (GCD) of two or more numbers. Contents: 1. Syntax 2. Explanation 3....

How to use the SMALL Function in Excel - 8 Examples

The SMALL function will return the smallest specified number from a given range or data set. For example, SMALL can return the 2nd...

How to use the LARGE Function in Excel - 8 Examples

The LARGE function will return the largest specified number from a given range or data set. For example, LARGE can return the 2nd largest...

How to use the FACTDOUBLE Function in Excel

The FACTDOUBLE function will return the double factorial of any inputted number. A double factorial is usually notated as any number with...

How to use the FACT Function in Excel

The FACT function will return the factorial of any inputted number. A factorial is usually notated as any number with a trailing...

bottom of page