writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 15:
Line 15: − + − + − +
no edit summary
=FACT(N)=
=FACT(Number)=
*where, <math>N</math> is a positive integer whose factorial is to be found.
*<math>Number</math> is a positive integer whose factorial is to be found.
FACT() calculates the factorial of a number <math>N</math> as 1*2*.....*<math>N</math>.
FACT() calculates the factorial of a number <math>N</math> as 1*2*.....*<math>N</math>.
<math>N! = N * (N-1) * (N-2) * ..... 1</math>
<math>N! = N * (N-1) * (N-2) * ..... 1</math>
*If <math>N</math> is negative, Calci displays #N/A error message.
*If <math>Number</math> is negative, Calci displays #N/A error message.
*If <math>N</math> is not an integer, it is truncated to calculate the factorial.
*If <math>Number</math> is not an integer, it is truncated to calculate the factorial.
*If <math>N</math> is invalid, Calci displays #NULL error message.
*If <math>Number</math> is invalid, Calci displays #NULL error message.
*The factorial of series of numbers can be calculated as -
*The factorial of series of numbers can be calculated as -
e.g. FACT(1..5) calculates factorial of numbers from 1 to 5 and displays result as '''1 2 6 24 120'''.
e.g. FACT(1..5) calculates factorial of numbers from 1 to 5 and displays result as '''1 2 6 24 120'''.