I am working on a school project where students fees information are to be updated in Google Sheet cells orderly. How can I update the fee into paid cells orderly?
If we have twelve months starting from April to March of next year, then -
If the monthly fee of the student is 2500, but he is paying 5000, then the fee must update into Apr and May month as 2500 & 2500. (equal to the monthly fee value and divide into two months equally)
Suppose, if a student already paid the fee worth 500 which is less than the monthly fee (2500) in Apr, and then in the next month he pays the amount of 5000, then the app can read the previous entry of 500 in April and then accordingly update the months of Apr , May & June cells as 2500, 2500 & 500 respectively.
I am really unable to construct a logic. Please help me.
I tried something like this, but it was unsuccessful.
Here are the blocks: