Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-3320395%22%20slang%3D%22de-DE%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3320395%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CSTRONG%3EHello%20everyone%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20am%20editing%20an%20excel%20sheet%20and%20I%20am%20looking%20for%20a%20calculation%20for%20a%20school%20project.%20Now%20I%20have%20the%20problem%20that%20I%20do%20not%20know%20how%20to%20create%20this%20calculation%20in%20Excel.%20Hope%20one%20of%20you%20can%20help%20me.%3C%2FP%3E%3CP%3E%3CSTRONG%3EMy%20goal%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20%22preference%20matrix%22%20and%20in%20this%20table%20I%20enter%20a%20value%200%2C1%20or%202.%20I%20enter%20something%20in%20one%20field%20and%20in%20another%20field%20the%20following%20must%20happen.%3C%2FP%3E%3CP%3E-%20If%20in%20field%20C15%20I%20enter%20the%20value%202%2C%20then%20in%20the%20other%20field%20D14%20I%20need%20automatically%20the%20value%200.%3C%2FP%3E%3CP%3E-%20If%20in%20field%20C15%20the%20value%201%20is%20entered%2C%20then%20I%20need%20in%20the%20other%20field%20D14%20automatically%20the%20value%201.%3C%2FP%3E%3CP%3E-%20If%20I%20enter%20the%20value%200%20in%20field%20C15%2C%20then%20I%20need%20automatically%20the%20value%202%20in%20the%20other%20field%20D14.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3320395%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3321293%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3321293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1381598%22%20target%3D%22_blank%22%3E%40Fabian_CH_-%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20enter%20this%20formula%20in%20cell%20D14%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIF(C15%3D2%2C0%2CIF(C15%3D1%2C1%2CIF(C15%3D0%2C2)))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EDoes%20this%20return%20you%20expected%20result%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?