Calculating Odds

[Harry0]

I saw this formula online but I seem to keep getting the wrong outcome.
n!/r!(n-r)! https://www.wikihow.com/Calculate-Lotto-Odds
I was trying to use multiple rows to be able to automatically adjust how many N and R the formula would have. Is anyone else getting a different number?

 

[Nikunj Rastogi]

Hi Harry,
I am getting the same answer . Hope you are not following BODMAS rule.
If n=69 and r=5 then the formula will be :
=(FACT(C2))/(FACT(C3)*(FACT(C2-C3)))

 

[Harry0]

Thanks
Your formula was simpler than mine since i did not use "fact" but a more elaborate confusing mess LOL. no i did not use bodma rule.

 

[bosco_yip]

Or,

If n=69 and r=5

Formula :

=COMBIN(69,5)

desired result rsturn: =11,238,513

Regards
Bosco