Recent Posts

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

Function

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

Function

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

Function

How to use the AVERAGE Function

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

Function

How to use the DELTA Function

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

Function

How to use the AND Function in Excel - 3 Examples

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

Tutorial

How to Extract Everything to The Right of a Specific Character in Excel

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

Function

How to use the BAHTTEXT Function in Excel with Examples

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

Function

How to use the DOLLAR Function in Excel with Examples

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

Function

How to use the FLOOR.MATH Function in Excel - 3 Examples

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

Function

How to use the CEILING.MATH Function in Excel - 4 Examples

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

Function

How to use the MROUND Function in Excel - 3 Examples

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

Function

How to use the ROUNDDOWN Function in Excel - 4 Examples

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

Function

How to use the ROUNDUP Function in Excel - 4 Examples

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

Function

How to use the ROUND Function in Excel - 4 Examples

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

Function

How to use the TRUNC Function in Excel - 3 Examples

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

Function

How to use the INT Function in Excel

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

Function

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

Function

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

Function

How to use the ARABIC Function in Excel to Convert Roman Numerals to Regular Numbers

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