Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use FACT Function in Excel (2 Suitable Examples)

We may often need to use the Math & Trig functions in Excel for different calculating purposes. In this article, I’ll introduce you to one of them that is the FACT function in Excel.

Excel FACT function

The above screenshot is an overview of the FACT function. This article will guide you with easy examples to use the application of the FACT function.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


Introduction to the FACT Function

Introduction to the FACT Function

The FACT function is a mathematical operator categorized under the Math & Trig function which is used to return the factorial of a number. Factorial of a number (n) can be calculated using the following formula:

n!=1*2*3*……*(n-1)*n

So the factorial of 5 will be-

5!=5*4*3*2*1=120

That means the factorial of a number is the multiplication of all the numbers decreased by 1 starting from the number and ending to 1.

Purpose of the FACT Function: 

The FACT function is used to get the factorial of a number.

Syntax:

=FACT(number)

Arguments:

Arguments Required/Optional Explanation
number Required The nonnegative number for which we want the factorial. If the number is not an integer then it is truncated.

Returns:

The factorial of a number.


2 Easy Examples of Using the Excel FACT Function

Let’s get introduced to our dataset first. I have used some integer, negative numbers, and non-numeric values in my dataset.


Example 1: Excel FACT Function in Worksheet

Now we’ll find the factorial of each value from the range B5:B12.

Steps:

⏩ Activate Cell C5.

⏩ Then type the following formula given below in it-

=FACT(B5)

⏩ Later, press the Enter button for the output.

FACT Function in Worksheet

Then you will get the factorial for 0 is 1.

FACT Function in Worksheet

To get the factorials for the other values just drag the Fill Handle icon.

FACT Function in Worksheet

Now you get all the factorials for the numbers like the image below. Take a look at the output that there are two errors. The FACT function will return #NUM if the given number is less than 0. It will show #VALUE if it finds a non-numeric value. And if the given number is not an integer then it will truncate the decimal portion that’s why the factorials of 4 and 4.5 are the same.

Read More: 51 Mostly Used Math and Trig Functions in Excel


Similar Readings


Example 2: FACT Function with Keyboard Shortcut

We can calculate the factorial of a number using the FACT function in a different way. Here, we’ll use a keyboard shortcut with the FACT function. Let’s see how to do it.

Steps:

⏩ Write the following formula in Cell C4

=FACT(

⏩ Then press Ctrl+A on your keyboard.

FACT Function with Keyboard Shortcut

A dialog box will open up.

⏩ Type the number in the Number box.

⏩ Finally, just press OK.

FACT Function with Keyboard Shortcut

Then you will see that the factorial is calculated.

Read More: 44 Mathematical Functions in Excel (Download Free PDF)


Conclusion

I hope all of the methods described above will be good enough to use the FACT function in Excel. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo