Recent Posts

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

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

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

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

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

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

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

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

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

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

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

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

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

A regular, one-way XLOOKUP, is a fantastic tool, but sometimes you may find yourself needing to lookup a value in two different...

Unwanted spaces can break formulas, formatting, and be the source of hard to track down errors. Here are a couple ways to remove them....