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
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Similar Threads - Microsoft Excel Factorials Date
Applications in Microsoft Store Jan 4, 2018
Microsoft Word just got Small Dec 2, 2017
Microsoft vs Apple: which is better? Oct 26, 2016
Rounding numbers in microsoft excel Dec 10, 2009
Microsoft Excel 2007 - Sub/Superscript Buttons Apr 21, 2009