Excel

Copper Contributor

Hello everyone

I am editing an excel sheet and I am looking for a calculation for a school project. Now I have the problem that I do not know how to create this calculation in Excel. Hope one of you can help me.

My goal:

I want to create a "preference matrix" and in this table I enter a value 0,1 or 2. I enter something in one field and in another field the following must happen.

- If in field C15 I enter the value 2, then in the other field D14 I need automatically the value 0.

- If in field C15 the value 1 is entered, then I need in the other field D14 automatically the value 1.

- If I enter the value 0 in field C15, then I need automatically the value 2 in the other field D14.

 

Thank you very much for your help.

 

 
1 Reply

@Fabian_CH_- 

You can enter this formula in cell D14:

=IF(C15=2,0,IF(C15=1,1,IF(C15=0,2)))

Does this return you expected result?