Excel Forum

hi there

I need your help how to calculate provision and Accrued interest receivable as per attached
Note:
loan class
1 Normal
2 Special mention
3 Sub standard
4 Doubtful
5 loss

thanks

...

For my mention, let’s break down the steps for creating provisions table range as the sample as I do in J to M columns and then use the VLOOKUP basically function for the provision calculation ( F G H columns) and in the same way for Accrued Interest.


Feel free to ask for further clarification if needed.


Bigcat9

BKK Thailand

thanks so much