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 !!!