Trouble with a formula

[jkeller]

I have been out of using excel formulas for a while and I am struggling with what I think should be a simple formula. I am trying to create a formula that says if cell A2 ="DE" and cell B2="SC" then C2 will show 6. If cell A2="DE" and Cell B2="DC" then cell C2 will show 12. and if cell A2 does not equal DE C2 will be blank.

 

[Fluff]

What happens if B2 does not equal SC or DC?

 

[jkeller]

What happens if B2 does not equal SC or DC?

If B2 does not equal SC or DC C2 would be blank.

 

[Fluff]

Ok, how about

=IF(A2="DE",IF(B2="sc",6,IF(B2="dc",12,"")),"")