May 04 2022 11:56 PM
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.
May 05 2022 01:16 AM
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?