-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
factorial
-
Factorial total number finding loop
I'm working to make a macro for my accounting team to look at a range of invoices that equal some user defined total. I've seen other solutions even using add-in Solver and none work as well as my version below. (No ego intended) PROBLEM: The problem is, my version below only goes out 4 levels...- Roderick_E
- Thread
- code fact factorial levels total
- Replies: 13
- Forum: Excel Questions
-
C
Factorial
Excel has excellent built in function FACT() which does n! calculations. But I don't need 1*2*3*4*5. Instead I need 1+2+3+4+5 calculation. Excel has such built in function? Thank You, AK- ctrnz
- Thread
- excel factorial
- Replies: 13
- Forum: Excel Questions
-
B
Factorials
Simply stated, I need a macro that will output all the combinations of 9!/5! There will be 3024 combinations. I don't want a non-repeating combination (like 9C5=126) or a repeating permutation (like 9P5=15120). Can anyone help me here? Thank you in advance.- bigmacfann
- Thread
- combination factorial permutation
- Replies: 5
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
