If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Truth Table
Thank you Jacob:
OK - I ran the macro and it resulted in a three column table of 27 rows....My apologies if I did not explain my intentions correctly.. I have 6 questions that may be answered yes or no, and for the sake of keeping everything in integer form, let's assume "1" for yes and "0" for no. Depending on how a customer answers all 6 questions, they will receive a predetermined score. I am attempting to develop the answer key, so-to-speak, to refer the reps to once they are finished asking the customer these questions. I was hoping for a table that would lay out all of the 6 question-answer combinations, like the following: Questions Scenario 1 Scenario 2 Scenario 3 Scenario 4 1 1 1 1 1 2 1 0 0 0 3 1 1 0 1 4 1 1 1 0 5 1 1 1 1 6 1 1 1 1 ....and so on, so that I am given all the possible 6 answer scenarios....Hopefully this helps out. Is it still only 27 possibilities? I thought, at the very least, 36…, no? Your help is greatly appreciated! Victoria "Jacob Skaria" wrote: 27 possibilities... Sub Macro() Dim lngRow As Long Dim intA As Integer, intB As Integer, intC As Integer For intA = 1 To 3 For intB = 1 To 3 For intC = 1 To 3 lngRow = lngRow + 1 Range("A" & lngRow).Resize(, 3) = Split(intA & "," & intB & "," & intC, ",") Next Next Next End Sub -- Jacob (MVP - Excel) "Victoria612" wrote: I stand corrected - is there a way to program a macro that can determine all 72 possible scenarios? "Victoria612" wrote: OK - I have 6 questions, all of which can be answered either yes or no. Is there a way to build a macro that can determine all 36 possible scenarios for me? For example: 1 Yes Yes Yes 2 No Yes Yes 3 No No Yes 4 No No No 5 No No No 6 No No No ....and so on. We can use other values for Yes and No, say True or False, or "1" or "0", respectively. Any help is greatly appreciated. Victoria |
Thread Tools | |
Display Modes | |
|
|