Conditional value, then other value is negative

[StevieP]

Hey,

I'm trying to create a conditional value so that if a cell contains a word then another cell will be negative...

For instance, say the cell A1 contains a drop down menu of Y and N, if A1=Y then A2 is formatted to be a negative number. So when I enter a value into A2 it will automatically be negative...

I've tried using this code:

=IF(A1="Y", -A2, A2)

In A2's cell, but obviously Excel doesn't like this...

Any ideas???