Excel 2007 : Drop down Yes or No fields require different result

Hi again,

need some help and i hope i can clarify it enough.

I have drop down down menu containing Y and N. I want a formula so that when i set N (no) the result is 0 (zero) and if Y (yes) i want to be from a specified cell i set.

For example in cell A10 i have Y and N drop down menu. When cell A10 is N the amount in cell B10 is 0 and when in cell A10 is Y then in cell B10 the result would be the amount located in cell C10.

thank you