Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Microsoft Excel Factorials Question

  1. May 5, 2004 #1
    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:


    Now obviously that comes back as an error. Does anyone have any ideas as how to add this equation?:
  2. jcsd
  3. May 5, 2004 #2


    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    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
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook