"IF" confusion

  • Thread starter Thread starter Jake Tucker
  • Start date Start date
J

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?
 
Back
Top