The Excel FACT function
returns the factorial of a given number.
Syntax
The syntax for the FACT
function in Microsoft Excel is:
=FACT( number )
Parameters or Arguments
number
A numeric value used to
calculate the factorial.
Excel Fact Function Examples
Cells A1-A3 of the following
spreadsheet shows examples of the Excel Fact function, used to calculate the
factorial of the integers 3, 6 and 10.
Formulas:
|
|
A
|
B
|
|
1
|
=FACT( 3
)
|
= 3 x 2 x
1
|
|
2
|
=FACT( 6
)
|
= 6 x 5 x
4 x 3 x 2 x 1
|
|
3
|
=FACT(
10 )
|
= 10 x 9 x
8 x 7 x 6 x 5 x 4 x 3 x 2 x 1
|
Results:
|
|
A
|
B
|
|
1
|
6
|
= 3 x 2 x
1
|
|
2
|
720
|
= 6 x 5 x
4 x 3 x 2 x 1
|
|
3
|
3628800
|
= 10 x 9 x
8 x 7 x 6 x 5 x 4 x 3 x 2 x 1
|
Notes
► If
the number is not an integer it will be truncated to an integer, then solved.
► If
the number is <0, then it will return #NUM error.
► If
the number is not number, then it will return #VALUE error.
References
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment