MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Factorial


Posted by Julio on March 14, 2001 7:10 PM

I need find the factorial betwen two number. For example, 3*4*5 , or 4*5*6*7*8 .

Please help me!


Posted by ml on March 14, 2001 7:37 PM

3*4*5
=Fact(5)/Fact(2)
or
=permut(5,3)

permut(n,k) will give you fact(n)/fact(n-k)

so 4*5*6*7*8
=Fact(8)/Fact(3)
or
=permut(8,5)