PDA

View Full Version : Microsoft Excel Factorials Question


Poweranimals
May5-04, 08:19 PM
I wasn't really sure what forum this belonged in, but I'm doing an equation with Microsoft Excel, using Factorials. Basically, I'm wondering how you go about using them in an equation. Here's my current equation:

=A5!/(A5-B5)!B5!

Now obviously that comes back as an error. Does anyone have any ideas as how to add this equation?:

chroot
May5-04, 08:30 PM
It took me less than thirty seconds to use Excel's help and find the "FACT" function, used to calculate a factorial.

Your equation should look like

=FACT(A5) * FACT(B5) / FACT(A5-B5)

(Assuming you intended to multiply by the factorial of B5 on the end -- I can't tell, because you used your parentheses sloppily.)

- Warren