Sir, I need your Help I'm doing a loan management system in excel. I cannot figure it out and don't know what to do to solve this problem.
Here in cell M5 when I enter data it is also visible in I5. now the data in J5 is decremented when there is data input in I5. What I would like is for I5 to input data instead of M5, but it is still the same function, the data is still reduced in J5.
Here is the Formula that I used
I5 =SUM(M5:M14)
J5 =SUM(I5-H5)
I have attached a file here so you can understand what I'm saying.