Results 1 to 3 of 3

Thread: All possible on/off combos of 4 variables

  1. #1
    Junior Member
    Join Date
    Aug 2017
    Posts
    7
    Rep Power
    0

    All possible on/off combos of 4 variables

    I have 4 variables "L S K B", any or all of which may either be "on" or "off". I need to get all possible on/off combinations . . . "- S K B", "L - K B", "L - - B", "L - - -", etc.

    Is there a formula for determining this for different numbers of variables?

  2. #2
    Senior Member
    Join Date
    Jun 2012
    Posts
    327
    Rep Power
    6
    In that case you have 5 variables in combinations of 4 elements.

  3. #3
    Junior Member
    Join Date
    Aug 2017
    Posts
    7
    Rep Power
    0
    Quote Originally Posted by snb View Post
    In that case you have 5 variables in combinations of 4 elements.
    I don't understand this "answer" at all.

    I need to know specifically what each of the possibilities are so that I will know that I have provided (outside of Excel) for every possibility.

Similar Threads

  1. Re: Defining multiple variables in VBA
    By MrIfOnly in forum Excel Help
    Replies: 13
    Last Post: 03-26-2017, 03:53 PM
  2. Populate Ribbon Controls On Load Dynamically Through VBA Variables
    By phxpoolplayer in forum Excel Ribbon and Add-Ins
    Replies: 1
    Last Post: 04-20-2013, 02:21 AM

Tags for this Thread

Posting Permissions

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