top of page
Recent Posts
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...
How to Use the CELL Function in Excel
The CELL function is a useful tool that allows you to retrieve specific information about a cell's formatting, location, and content....
How to Use the CODE Function
The CODE function will return the ASCII value of the first character from any text string. Contents: 1. Syntax 2. Explanation 3. Examples...
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 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...
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....
How to use the CLEAN Function
The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...
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...
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 -...
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...
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...
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...
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...
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...
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...
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...
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...
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...
bottom of page