If Condition Formula based on values from dropdown

Hi All,

Need your help and support please..

I have data like the attached.. column C has drop down list and column A and B has values. I am trying to write an IF condition formula .. If “X” is selected from the dropdown in column C, then it should be column B – column A. the formula for that is

Please Login or Register  to view this content.

.

Similarly If “Y” is selected from the dropdown in column C, then it should be column A – column B. The formula for that is

Please Login or Register  to view this content.

Both these formulas works separately but doesn’t works when combined.. I tried with

Please Login or Register  to view this content.

but its not working..

Attached is the sample data.. Please help..

Originally Posted by AliGW

The parenthesis was wrong. In C2 copied down:

=IF(C2="X",B2-A2,IF(C2="Y",A2-B2))

Thank you so much.. Its works perfectely fine ..

Originally Posted by Sam Capricci

you might want to adjust it to this... =IF(C4="X",B4-A4,IF(C4="Y", A4-B4,""))
and drag down.

Thank you so much.. Its working fine ..