If Cell Contains Text Then Return Value In Another Cell

I use Excel to manage my bank and to make life easier I need the following doing (if possible)

See attached.. I have a list of my bills along with it's Due Date and if it's been paid or not (The "Paid" column has drop-down menu so I can select "Yes" or "No")

Example:

If E10 is displaying "Yes" then D10 will display 0.00
If E10 is displaying "No" then D10 will display whatever number I want it too
&
When I enter a number greater than 0, it changes the "Paid" on E10 to "No"

This way I can enter my monthly bills, and once I've paid it, I can select "Yes" and it'll automatically change the "Due Now" to 0, resulting in the total being correct for the bills I've got left to pay, and then when I enter a new amount for my bill next month, it'll change D10 back to "No" until I select "Yes" again.

Then also, if possible, once I enter a number into any of the "Due Now" columns, then it changes the "Paid" to "No" . Is there any way to do this?

Untitled.png‎