Posts

Showing posts with the label FACT

FACT Function in Excel

Image
In this blog post we will learn to about FACT function in excel. Whenever we want to return factorial of a number, we can use FACT function which is readily available in excel. What is Factorial of number? In mathematics, factorial of a number is calculated by multiplying all the numbers which are less than the provided number. For example, if we want to calculate factorial of 5 then it will be 5x4x3x2x1 = 120. i.e., factorial of 5 is 120. Where to find FACT function on Excel Screen: FACT function can be found under “Math & Trig” function category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Math & Trig” function category, we can see list of various Math & Trig functions available in excel. FACT function is highlighted in blue in below image. Once we click on FACT option as highlighted above, we will get the function argument dialog box as shown in below image. Syntax of FACT Function: The Syntax of FACT function is as b...