Formulas and Functions

%3CLINGO-SUB%20id%3D%22lingo-sub-2228951%22%20slang%3D%22en-US%22%3EFormulas%20and%20Functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2228951%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWas%20hoping%20to%20get%20advice%20on%20creating%20a%20formula%20in%20Excel.%3C%2FP%3E%3CP%3EI%20want%20cell%20H2%20to%20change%20to%20%221%22%20if%20cell%20C2is%20B%3C%2FP%3E%3CP%3Eand%20also%3C%2FP%3E%3CP%3Ecell%20D2%20to%20change%20to%20%220%22%20if%20cell%20C2%20is%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThankyou.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2228951%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

Was hoping to get advice on creating a formula in Excel.

I want cell H2 to change to "1" if cell C2is B

and also

cell D2 to change to "0" if cell C2 is B

 

Thankyou.

1 Reply
In cell H2: =IF(C2="B",1,"") In cell D2: =IF(C2="B",0,"") You didn't specify what the cell values should be if C2 is not B, so I am using "" (blank).