Applies ToSharePoint Server-Abonnementedition SharePoint Server 2019 Microsoft Office SharePoint Online Server 2016 SharePoint Server 2013 Microsoft Office SharePoint Online Server 2013 Enterprise SharePoint in Microsoft 365 Microsoft Office SharePoint Online Foundation 2010 Microsoft Office SharePoint Online Server 2010 SharePoint in Microsoft 365 Small Business

Returns the factorial of a number. The factorial of a number is equal to 1*2*3*...* number.

Syntax

FACT(number)

Number     is the nonnegative number you want the factorial of. If number is not an integer, it is truncated.

Examples

Formula

Description (Result)

=FACT(5)

Factorial of 5, or 1*2*3*4*5 (120)

=FACT(1.9)

Factorial of the integer of 1.9 (1)

=FACT(0)

Factorial of 0 (1)

=FACT(-1)

Negative numbers cause an error value (#NUM!)

=FACT(1)

Factorial of 1 (1)

Benötigen Sie weitere Hilfe?

Möchten Sie weitere Optionen?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.