Microsoft Excel Factorials Question

  • Thread starter Thread starter Poweranimals
  • Start date Start date
  • Tags Tags
    Excel Factorials
Click For Summary
SUMMARY

The discussion focuses on calculating factorials in Microsoft Excel using the "FACT" function. The original equation provided by the user, =A5!/(A5-B5)!B5!, was incorrect and resulted in an error. Warren clarified the correct formula, which is =FACT(A5) * FACT(B5) / FACT(A5-B5), ensuring proper use of parentheses for accurate calculations.

PREREQUISITES
  • Basic understanding of Microsoft Excel functions
  • Familiarity with mathematical concepts of factorials
  • Knowledge of Excel syntax and formula structure
  • Experience with error troubleshooting in Excel
NEXT STEPS
  • Learn how to use the "FACT" function in Microsoft Excel
  • Explore advanced Excel functions for statistical calculations
  • Research common Excel errors and their resolutions
  • Study the application of factorials in combinatorial mathematics
USEFUL FOR

This discussion is beneficial for Excel users, mathematicians, and anyone involved in data analysis or statistical calculations who seeks to understand factorial computations in Excel.

Poweranimals
Messages
68
Reaction score
0
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?:
 
Computer science news on Phys.org
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

  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 13 ·
Replies
13
Views
2K
Replies
8
Views
4K
  • · Replies 5 ·
Replies
5
Views
2K
Replies
4
Views
3K
Replies
7
Views
8K
  • · Replies 41 ·
2
Replies
41
Views
7K
Replies
18
Views
11K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 14 ·
Replies
14
Views
9K