Conditional IF statements I need to calculate a new variable. Label1 is the trum

Question

Conditional IF statements

I need to calculate a new variable. Label1 is the trump card, if Label1=Y, then all cases will be coded with Label1. If Label1=N, then label7 becomes the trump card, if Label7=Y, then all cases will be coded with Label7. If both Label1 and Label7 are "N" then the case will be coded with that appropriate label (Label2-Label6).

Thank you!

Label1 Label2 Label3 Label4 Label5 Label6 Label7 N N N N N Y N N N N N N Y N N N N N N Y N N N N N N Y N Y N N N N Y N N N N N N Y N N N N N N Y N N Y N N N Y Y

Explanation / Answer

&*%#%&

I think can use this fomula (assuming you will use create a parallel table to apply this formula).

Columns A to G and row 1

if($a2="Y","Y",if($G2="Y","Y",a2)

I tried this myself and this formula appears to work for all cells irrespective of any row or column.

Just try and vote for me if it works

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---