Forum Discussion
Formula to calculate between "Closing Balances"
Hi, I have a sheet which uses formula to calculate balance for repayments and draw for a facility. Each period can have a different number of draws & repayments, but i wish to have a summary ba...
=IF(B2="Closing Balance",SUMIF(A:A,A1,P:P),IF(AND(N2=0,B2="Beginning Balance"),O2*(L2+M2)*(DAYS(K2,J2)+1)/365,N2*(L2+M2)*(DAYS(K2,J2)+1)/365))This formula can be copied down across all rows.
Cheers,
--
LR