Mar 01 2022 06:31 AM - edited Mar 01 2022 06:32 AM
Mar 01 2022 06:59 AM
Mar 01 2022 07:46 AM
I moved the formula over to M12, I need =COUNTIF(F12:J12,0)*100 and =L12-K12 to be in the same cell.
In this situation L12 is our beginning balance, K12 is our total paid and M12 is our ending balance. I need our total paid (K12) to be subtracted from the beginning balance (L12) and combined with the formula you gave me above in (M12) . For every unpaid week we will put a 0 which adds the 100 to the ending balance in M12 calculating the total unpaid balance including the 100 added for each 0 as well as total partial payments or full payments inputed in F12:J12. I have a formula in K12 giving the sum of F12:J12.
For example see the screenshot I have included.