"IF" confusion

[Jake Tucker]

My spreadsheet looks like this:

D9 E9
Amount Yes/No
$500 No

If the user types in Yes, the $500 stays the same.
If the user types in No, the amount should change to $0.00

I have tried =IF(E9="YES","500","NO")

But I keep getting a circular reference..
What am I doing wrong? Should my formula be in cell d9 or e9?

 

[Bob Phillips]

D9: =IF(E9="YES",500,0)

 

[Jake Tucker]

Thank you, Bob!
--
Jake T.

D9: =IF(E9="YES",500,0)

--
__________________________________
HTH

Bob

 

[Jake Tucker]

Thank you, Bob!
--
Jake T.

D9: =IF(E9="YES",500,0)

--
__________________________________
HTH

Bob