Function: LN

Function: LN

The Excel LN function is a Math formula that returns the natural logarithm of a given number. The natural logarithm of a number is the power to which e would have to be raised to find that number. Natural logarithms are based on the constant e which is approximately...
Function: EXP

Function: EXP

The Excel EXP function is a Math formula that returns the value of the constant e (Euler’s number) raised to the power of a given number (ex). The constant e is approximately equal to 2.71828, which is the base of the natural logarithm. In this guide, we’re...
Function: FACTDOUBLE

Function: FACTDOUBLE

The FACTDOUBLE is a Math function that returns the double factorial of a given number. Also known as the semi-factorial, double factorial of a number (n) is shown as n!! and is equal to n x (n-2) x (n-4) x … 4 x 2 for an even number, and n x (n-2) x (n-4) x...
Function: FACT

Function: FACT

The Excel FACT function is a Math formula that returns the factorial of a given number. Factorial of a number n (denoted as n!) is the product of all numbers that are less than or equal to that number (n! = n x (n-1) x (n-2) x … x 2 x 1).  Frequently used in...
Function: LCM

Function: LCM

The Excel LCM function is a Math formula that returns the least common multiple (LCM) of two or more numbers. Also known as lowest common multiple or smallest common multiple, the least common multiple will give you the smallest positive number that is divisible by a...
Function: GCD

Function: GCD

The Excel GCD function is a Math formula that returns the greatest common divisor (GCD) of two or more numbers. The greatest common divisor of a set of values is the largest positive number that divides each number. In this guide, we’re going to show you how to use...
Function: CEILING

Function: CEILING

The Excel CEILING function is a Math formula that rounds a given number up to the nearest multiple of significance. This function is the predecessor of the CEILING.MATH function which was released in Excel 2013. In this guide, we’re going to show you how to use the...
Function: FLOOR

Function: FLOOR

The Excel FLOOR function is a Math formula that rounds a given number down to the nearest multiple of significance. This function is predecessor of the FLOOR.MATH function that was released in Excel 2013. In this guide, we’re going to show you how to use the FLOOR...
Function: CEILING.MATH

Function: CEILING.MATH

The CEILING MATH (CEILING.MATH) is a Math function that rounds a given number up to the nearest multiple of significance. This function has been released with 2013 version as a replacement for the CEILING function. In this guide, we’re going to show you how to use the...