Recent Posts

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 GCD function finds and returns the greatest common divisor (GCD) of two or more numbers. Contents: 1. Syntax 2. Explanation 3....

The AVERAGE function returns the arithmetic mean of any set of numbers given to it. Contents: 1. Syntax 2. Explanation 2.1. Types of...

The DELTA function compares two numbers and returns a 1 if they are the same, and a 0 if they are not the same. Contents: 1. Syntax 2....

The AND function checks if all provided conditions in the function are true, and returns a TRUE. If any of the conditions are false, a...

A lot of time spent in Excel is used to clean up data that may not be immediately useful into something valuable. Being able to break up...

The BAHTTEXT function will convert any number into Thai text while applying a "Baht" suffix. Contents: Syntax Explanation Example -...

The DOLLAR function will convert any number into text while applying the standard dollar currency format. Contents: Syntax Explanation...

The FLOOR.MATH function will round any number down to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The CEILING.MATH function will round any number up to the nearest integer and if desired, a specific multiple. Contents: Syntax...

The MROUND function will round any number up or down to the nearest given multiple. Contents: Syntax Explanation Different Methods of...

The ROUNDDOWN function will round any number down to a specified number of digits. This function differentiates itself from the standard...

The ROUNDUP function will round any number up to a specified number of digits. This function differentiates itself from the standard...

The ROUND function will round any number to a specified number of digits. There are plenty of real world situations in which you wouldn't...

The primary use of the TRUNC function is to truncate or remove the fractional part of a number. The function can be configured to remove...

The INT function will round any input number down to the nearest integer, removing the decimal, or fractional, portion of the number....

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

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

The ARABIC function converts Roman numerals into Arabic numerals, letting you easily convert Roman numerals into a more readable format....