by Ilker | May 30, 2019 | Excel Formulas

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...
by Ilker | May 29, 2019 | Excel Formulas

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...
by Ilker | May 29, 2019 | Excel Formulas

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...
by Ilker | May 29, 2019 | Excel Formulas

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...
by Ilker | May 28, 2019 | Excel Formulas

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...
by Ilker | May 27, 2019 | Excel Formulas

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...
by Ilker | May 24, 2019 | Excel Formulas

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...
by Ilker | May 24, 2019 | Excel Formulas

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...
by Ilker | May 21, 2019 | Excel Formulas

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