Microsoft Excel Factorials Question

Poweranimals

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

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

Similar Threads for: Microsoft Excel Factorials Question
Thread	Forum	Replies
Formula for Microsoft Excel®'s FV function??	General Math	5
Microsoft VBA Excel help! (Please)	Engineering, Comp Sci, & Technology Homework	1
microsoft excel help	Programming & Comp Sci	2
Microsoft Excel Question	General Engineering	8
Prevent the automatic creation of hyperlinks in Microsoft Excel	Computing & Technology	0

Poweranimals	Microsoft Excel Factorials Question Tweet 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 Recognitions: Gold Member Science Advisor Staff Emeritus	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