"IF" confusion

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timesheet Calculation 8
Mail Merge Help 1
Match & IF 1
Help with Formula 3
Outlook 365 Signatures 0
Removing #N/A from an "If/Then" statement 4
Payment calculation 1
IF(AND with date comparison 4

Top