I've developed a spreadsheet for my personal budget. Column D is amount for all bills or income for the entire month and E is for outstanding bill or income for the month. Column B is currently using data validation with the options of "Paid" or "Not Paid" to pick from the dropdown list. I would like to make a change where If column B is changed from "Not Paid" to "Paid" it will automatically change column E for each specific cell within that column to reflect that cell to display 0. I've looked at options from If statement and others but struggled to find the right function to make this happen. Any suggestions? If I need another approach to make this happen, that would be no problem. Thanks!