+ Reply to Thread
Results 1 to 3 of 3

How to do combinations?

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    portland, oregon
    MS-Off Ver
    Open Office
    Posts
    3

    Question How to do combinations?

    I am doing combinations math with the formula

    R! / N! (R-N)!

    I do not seem able to make this formula work in Open Office. Can someone help me? I'm trying to use the formula to do 15,000 calculations based upon another data source but doing them individually would suck..

  2. #2
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: How to do combinations?

    I'm not sure about open office, but in Excel factorials are implemented with the fact() function, so a combinations formula would look something like:
    =FACT(10)/(FACT(3)*FACT(10-3))

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: How to do combinations?

    Exactly what formula are you trying? What are the values for R and N? Something like =FACT(R)/FACT(N)/FACT(R-N) should work -- unless R or N are large enough to cause an overflow error (#NUM).
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Combinations
    By lorber123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-29-2016, 07:29 PM
  2. [SOLVED] All combinations
    By tsakta13ole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2016, 02:28 PM
  3. Combinations of 1-6
    By carterja80 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2015, 03:55 PM
  4. Help with combinations
    By vidaLL in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-26-2013, 03:08 AM
  5. Finding possible combinations & listing the wanted combinations
    By Zoke in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 07-16-2012, 03:41 PM
  6. Excel 2007 : Combinations
    By freehawk in forum Excel General
    Replies: 1
    Last Post: 12-18-2010, 12:05 PM
  7. Combinations
    By osprey in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1