Forum Discussion
Excel Spreadsheet Formula Question
Hello, I am trying to set up a spreadsheet with a payment plan formula. Cells C2 thru Y2 are my monthly payments. Cell B3 is the totaled owed and I want to display the balance as the payments are made in cells C2 thru Y2 on cell B4. I have tried to set it up, but, have had no luck. Can some assist with this formula. Thank you in advance.
3 Replies
JLS357 Enter this in B4:
=B3-SUM(2:2)It will take the Total and deduct the sum of all numbers entered on row 2. Of course, you may limit the sum range to C2:Y2. Your choice!
In case you enter the monthly payments as negative amounts, you obviously need to change the minus sign in the formula to a plus sign.
Mr. Eekelen, sir, thank you very, very, much for your assistance. I have spent many hours during several days in trying to figure this out. I tried your formula and it worked. Again, thank you very much for your reply and assistance. Stay safe to you and your family.Riny_van_Eekelen
JLS357 You are most welcome! Stay safe.
