Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel formula and function

0

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.

Answer
Discuss

Discussion

Hi Nephi40 and welcome to the Forum.

Unfortunately you did not attach the file to your question.   Please edit your question and use the Add Files... button to upload a representative Excel file (without any personal data) to show your existing data. Then we should be able to give specific help.
John_Ru (rep: 6102) Jan 27, '23 at 9:31 am
Add to Discussion

Answers

0

Nephi40

You didn't attach a file to your question but the formula in I5:

=SUM(M5:M14)

means the value I5 is M5+M6+...+M14 so if you put a value in M5, it appears in I5.

If you want J5:

=SUM(I5-H5)

to be affected directly by I5, just delete the formula in I5 and type your value in I5.

In fact, the formula in J5 can be simply:

=I5-H5

Hope this helps- if so, please mark this Answer as Selected

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login