There are 5 option columns, which are populated with an x for whichever
option applies. There are only 3 options, two have two columns, and one has
one column.
I am looking for a formula for the three output columns. The formula needs
to look at the 5 columns, determine which column has the x, and then either
populate the output column with a zero, if the x doesn't apply, or with a
number (from another column) if the x does apply.

Your description leaves too much to the imagination.

I'll assume that the first ouput column will analyze the first option,
represented by columns A and B, and the number (from another column) is in
col G

=if(OR(A2="x",B2="x"),G2,0)

"ERG" wrote:

There are 5 option columns, which are populated with an x for whichever
option applies. There are only 3 options, two have two columns, and one has
one column.
I am looking for a formula for the three output columns. The formula needs
to look at the 5 columns, determine which column has the x, and then either
populate the output column with a zero, if the x doesn't apply, or with a
number (from another column) if the x does apply.