• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula for Outstanding balance after deducted 2 months Final Prepaid sum

Yvonneyeong

New Member
Hi all, can please help on the formulation for installment no.: 29/30 become "0" after deducted 2 months Final Prepaid sum :)
 

Attachments

  • HP Sch_ORIX 2018 (126910).xlsx
    15.2 KB · Views: 6
Hii @Yvonneyeong ,

Could you please share what logic do you want in formula so we will help you better also please provide your desire output by manually ,


Regard
Rahul shewale

Right, my current Outstanding Balance formula is as follow:
Current month = Jul-19
Current Month formula =INDEX(G16:G45,MATCH(H1,F16:F45))

But, i need the formula on instalment 29/30 to show "0" figure in which that last 2 final month already paid when signed-up the Hire Purchase Agreement.
Please HELP !!!
 

Attachments

  • HP Sch_ORIX 2018 (126910).xlsx
    15.7 KB · Views: 3
You haven't give us your desired result, just guess ........

1] Add information of Pre-payment in range D11:E12

2] In G16, formula copied down :

=IF(A16=B$11,0,IF(ROWS($1:1)<=E$11,ROWS($1:1)*B$12,C$9-SUM(INDEX(C$16:C$45,E$11+1):C16)))

Regards
Bosco
 

Attachments

  • HP Sch_ORIX 2018 (126910)-BY.xlsx
    17.1 KB · Views: 4
Back
Top