Hi All, can anyone assist with a formula for the following :
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]609[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]i[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]U[/TD]
[TD="align: center"]V[/TD]
[/TR]
[TR]
[TD]610[/TD]
[TD]
[/TD]
[TD]Description[/TD]
[TD]Prop.[/TD]
[TD]Vat[/TD]
[TD]Dr Amount[/TD]
[TD]Vat[/TD]
[TD]Cr Amt[/TD]
[TD]Vat[/TD]
[TD="align: center"]Total[/TD]
[TD]Days[/TD]
[TD="align: center"]5%[/TD]
[TD]
[/TD]
[TD="align: center"]Total[/TD]
[/TR]
[TR]
[TD]611[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]2,668,666.46[/TD]
[/TR]
[TR]
[TD]612[/TD]
[TD]2017-01-30[/TD]
[TD]Loan - In[/TD]
[TD]Eaton[/TD]
[TD="align: center"]n[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]200,000.00[/TD]
[TD]
[/TD]
[TD]200,000.00[/TD]
[TD]115[/TD]
[TD]-43,180.69[/TD]
[TD]
[/TD]
[TD]2,768,666.46[/TD]
[/TR]
[TR]
[TD]613[/TD]
[TD]2017-02-10[/TD]
[TD]Loan - Out[/TD]
[TD]Eaton[/TD]
[TD="align: center"]n[/TD]
[TD]100,000.00[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Currently in use Loan - In with the following formula that works :
Cell S612 : =IF(E611="Loan-In",C612-C611,S611+C612-C611)
Cell T612 : =IF($612="Loan-In",(V611+SUM(T$6:T611))*0.05/365*S612,0)
Cell V612 : =IF(E612="Loan-In",V611+R612,V611)
Would like a formula if a Loan-Out amount of 100,000.00 is included.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]609[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]i[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[TD="align: center"]L[/TD]
[TD="align: center"]S[/TD]
[TD="align: center"]T[/TD]
[TD="align: center"]U[/TD]
[TD="align: center"]V[/TD]
[/TR]
[TR]
[TD]610[/TD]
[TD]
[/TD]
[TD]Description[/TD]
[TD]Prop.[/TD]
[TD]Vat[/TD]
[TD]Dr Amount[/TD]
[TD]Vat[/TD]
[TD]Cr Amt[/TD]
[TD]Vat[/TD]
[TD="align: center"]Total[/TD]
[TD]Days[/TD]
[TD="align: center"]5%[/TD]
[TD]
[/TD]
[TD="align: center"]Total[/TD]
[/TR]
[TR]
[TD]611[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]2,668,666.46[/TD]
[/TR]
[TR]
[TD]612[/TD]
[TD]2017-01-30[/TD]
[TD]Loan - In[/TD]
[TD]Eaton[/TD]
[TD="align: center"]n[/TD]
[TD][/TD]
[TD]
[/TD]
[TD]200,000.00[/TD]
[TD]
[/TD]
[TD]200,000.00[/TD]
[TD]115[/TD]
[TD]-43,180.69[/TD]
[TD]
[/TD]
[TD]2,768,666.46[/TD]
[/TR]
[TR]
[TD]613[/TD]
[TD]2017-02-10[/TD]
[TD]Loan - Out[/TD]
[TD]Eaton[/TD]
[TD="align: center"]n[/TD]
[TD]100,000.00[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
Currently in use Loan - In with the following formula that works :
Cell S612 : =IF(E611="Loan-In",C612-C611,S611+C612-C611)
Cell T612 : =IF($612="Loan-In",(V611+SUM(T$6:T611))*0.05/365*S612,0)
Cell V612 : =IF(E612="Loan-In",V611+R612,V611)
Would like a formula if a Loan-Out amount of 100,000.00 is included.