Recent Posts

How to Calculate Number of Weekend Days Left in the Current Month in Excel

A quick formula to calculate the number of weekend or non-working days remaining in the current month. Contents: 1. Formulas 2....

Function

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

Function

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

Function

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

Function

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

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

The CLEAN function removes all non-printable characters from a text string. Characters like line breaks, tabs, and other characters that...

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

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