Conditional output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Excel Help with dates 2
Solve for a number (x) 2
Conditional Formatting based on a vertical Array. 2
Calculating column A * column B = Results in another column 2
Conditional Format 2
Excel VBA 1
Index Match on Columns and Rows 0

Back
Top