Excel: how would I have one cell words make another cell =0

Question

He all, I am wanting to improve my bill payment workbook I made. What I would like happen is that when the cell next to one says "Paid" it will be the next cell changes its value to "0" or become blank. This is so that I can just click a drop down that says paid and not have to play the game of deleting something after I pay it to change the sum value.

Thank you all

Answer 1

You can create macro (that you execute with a shortcut key) that will set the selected cell to "Paid" and clear the cell to the right (or left).

Answer 2

Hi,

Does this cell that needs to be changed to a value of 0 have a numeric value?

If these two columns are added to the auxiliary columns of the table, you can directly use the IF function to implement your needs.

If your table is more complex, please be a bit more precise to explain your requirement or you can upload a screenshot or sample table so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.