Skip to main content

FACT

Definition of FACT

Returns the factorial of a number.

Sample Usage

FACT(3)

FACT(A2)

Syntax

FACT(value)

  • value - The number or reference to a number whose factorial will be calculated and returned.

Notes

  • If a number or reference to a number with a decimal part is provided to FACT, the decimal part will be silently truncated before calculation.

See Also

MULTINOMIAL: Returns the factorial of the sum of values divided by the product of the values' factorials.

FACTDOUBLE: Returns the "double factorial" of a number.

COMBIN: Returns the number of ways to choose some number of objects from a pool of a given size of objects.

In order to use the FACT formula, start with your edited Excellentable

 

Then type in the FACT Formula in the area you would like to display the outcome:

 

Type in the complete FACT formula for a cell as shown below:

 

Excellentable will generate the outcome when hitting enter. 

 

A
B
C
1
State
Population
Total area in mi2
Land area in mi2
Water area in mi2
2
Alabama
4833722
52,420 (135,767)
3
Alaska
735132
665,384 (1,723,337)
4
Arizona
6626624
113,990 (295,233)
5
Arkansas
2959373
53,179 (137,733)
6
California
38332521
163,695 (423,968)
7
Colorado
5268367
104,094 (269,602)
8
Connecticut
3596080
5,543 (14,356)
9
Delaware
925749
2,489 (6,446)
10
Florida
19552860
65,758 (170,312)
11
Georgia
9992167
59,425 (153,910)
12
Hawaii
1404054
10,932 (28,314)
13
Idaho
1612136
83,569 (216,443)
14
15
120
D
E
F
1
House seat(s)
2
50,645 (131,170)
1,775 (4,597)
7
3
570,641 (1,477,950)
94,743 (245,383)
1
4
113,594 (294,207)
396 (1,026)
9
5
52,035 (134,770)
1,143 (2,960)
4
6
155,779 (403,466)
7,916 (20,502)
53
7
103,642 (268,432)
452 (1,171)
7
8
4,842 (12,541)
701 (1,816)
5
9
1,949 (5,048)
540 (1,399)
1
10
53,625 (138,888)
12,133 (31,424)
27
11
57,513 (148,958)
1,912 (4,950)
14
12
6,423 (16,635)
4,509 (11,678)
2
13
82,643 (214,044)
926 (2,398)
2
14
15

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.