Entering Factorials to Exce

[Yule]

Have been given formula for calculating number of people befor more than 50% probability of two with same birthday. Wish to claclulate table of answers in excel. Uses functions Factorial (FACT) and to the power of (Power). Can not enter 'FACT(365)' into ecxel, probably too large a number.
Is there a solution?

[Perfect Agent52]

try to use an equal sign before the FACT. Or just try to break down the number.

[Yule]

Advice accepted. Excel cannot cope with factorial 365. So have built a table for values of n in the equation People = Factorial 365/(factorial 365-n).
23 people result in a 50% probability of shared birthdays. 73 people and it is a statistical certainty.

[Perfect Agent52]

Sounds like a good equation. I even learned something there. Didn't that the code what allow that big of a number, but good job on the equation.