single if statement to replace multi?

[Nuclear_Dude]

I have the following data:
__24__|__48___|__120__|__125__|__208__|__240__|__250__| ...
_true | true_ | false | false | false | false | false | ...
false | false | _true | false | _true | false | false | ...
false | false | _true | false | false | _true | false | ...
false | false | false | _true | false | false | _true | ...
false | false | false | _true | false | false | false | ...
__.___|___.___|___.___|___.___|___.___|___.___|___.___| ...
__.___|___.___|___.___|___.___|___.___|___.___|___.___| ...
__.___|___.___|___.___|___.___|___.___|___.___|___.___| ...


you may have noticed that these are common voltages.
What I need is to condense the information into a single column, that reads "120" if it is a single voltage, but "120/208" or maybe "120/240", but if more than two columns are true or NO columns are true (both are possible, but not shown above), I need it to show FALSE, or ERROR, or whatever.

One way to accomplish this is with IF statement nesting, but I have 12 different voltage combinations, so that is a REALLY long if statement, and it would need a countif at the beginning to make sure there is at least one true, but not more than two. What I need done is the following:
For(A2:L2, if(cell)=true, output=output+"cell"$1)
so the first run would be in cell A2:
if(A2=true), output=output+A1+"/";
if(B2=true), output=output+B1+"/";
if(C2=true), ...
and the final output would be in the form of "###/###" or "###" or an error if there is no true or if there is more than 2 trues.

Thanks, and please let me know if you need clarification on the question. Below is my current, extremely unelegant solution:
-------
M2 = if(or(countif(A2:L2,TRUE)=1,countif(A2:L2,TRUE)=2),
if(A2,M2&$A$1,...

 

[kpark91]

I am NOT very good which formulas..

So, here is a vba code.

Before this macro,
in a column N, you should input
"=countif(A2:L2, TRUE)"
This formula should give you number of occurrences of TRUE in A2:L2.
If you've confirmed the formula is correct, copy down.

Sub getFinalOutput()
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Dim i As Long, j As Long
 
 
    For i = 1 To Range("A" & Rows.count).End(xlUp).Row
        For j = 1 To 12
            If Cells(14, i).Value = 2 And Cells(j, i).Value = True Then
                Cells(13, i).Value = Cells(j, i).Value & "&"
                Cells(14, i).Value = 1
            ElseIf Cells(14, i).Value = 1 And Cells(j, i).Value = True Then
                Cells(13, i).Value = Cells(13, i).Value & Cells(j, i).Value
            Else
                Cells(13, i).Value = "ERROR"
            End If
        Next j
    Next i
 
    Application.ScreenUpdating = True
    Application.Calculation = xlCalculationAutomatic
End Sub

To use this code, right click on the worksheet you're working with and click "View Code"
Copy + Paste the code onto the editor and hit F5 to run the macro.

 

[Peter_SSs]

This is still a bit of a mouthful but see if it does what you want.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	24	48	120	125	208	240	250
2	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE						24/48
3	TRUE	FALSE	TRUE	FALSE	TRUE	FALSE	FALSE						Error
4	FALSE	FALSE	TRUE	FALSE	FALSE	TRUE	FALSE						120/240
5	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE						Error
6	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE						125
Voltages