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....

top of page

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 ASIN Function

The ASIN function is used to return the arcsine of a number in radians. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating...

How to Use the ACOT Function

The ACOT function is used to return the arccotangent of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating...

How to Use the ACOS Function

The ACOS function is used to return the arccosine of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating Arccosine...

How to Use the ATAN Function

The ATAN function is used to return the arctangent of a number. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Calculating Arctangent...

How to Begin a Cell with an =, -, or + Sign Without Creating a Formula

Sometimes you find yourself wanting to start a cell with an "=", "-", or a "+" sign, but don't want Excel to create a formula. There are...

How to Use the IMSUB Function

The IMSUB function is used return the difference between two complex numbers. Contents: 1. Syntax 2. Explanation 3. Example 3.1....

How to Use the IMSUM Function

The IMSUM function is used add or sum two or more complex numbers. Contents: 1. Syntax 2. Explanation 3. Example 3.1. Adding Two Complex...

How to Use the IMSQRT Function

The IMSQRT function returns the square root of a complex number. Contents: 1. Syntax 2. Function Explanation 3. Example 3.1. Returning...

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 IMREAL Function

The IMREAL function is used to extract the real coefficient of a complex number. Contents: 1. Syntax 2. Explanation 3. Example 3.1....

How to Use the IMAGINARY Function

The IMAGINARY function is used to extract the imaginary coefficient of a complex number. Contents: 1. Syntax 2. Explanation 3. Example...

How to Use the IMABS Function in Excel

The IMABS function is used to find the absolute value of a complex number. It takes a complicated formula and turns it into a...

bottom of page