How to

[eazyyexcel]

Hi there,

I have attached the excel file. I would like cell column D to display the total and plus and minus from column C. For example if column D balance is 40,000 And in column C is keyed in +10,000 then the balance will be 50,000 but if we key in -10,000 then the total will become 30,000. The formulas will be keyed in for column D.

Thank you

 

[Ezguy4u]

eazy This should be the solution to your problem. If there is something I am missing let us know.

Book1
	A	B	C	D	E
1	MOM PAYMENT
2	Date	Description	Amount	Total Balance	Remarks
3	9/3/2024	mom paid cash	40,000	40,000
4			-10,000	30,000
5			10,000	40,000
6			10,000	50,000
Sheet1

Cell Formulas
Range	Formula
D4:D6	D4	=IF(C4="","",D3+C4)

 

[eazyyexcel]

Thank you for the quick response! The formula is working great but the balance is not showing until I key in the value at cell C4. I prefer to see the value instead of it being empty until I key in the data. I have attached the screenshot. Please help. Thank you

 

[Ezguy4u]

Ok eazy the formula is working. This is a good start. This tells us that the math formula is giving you the amount you are expecting. Now we have to address your next problem or concern. You have attached a screenshot that doesn't really help me understand your problem or concern. And your written description of the problem, is kind of confusing to me. This is not that unusual as most of the time I am always confused. So let me brack down the words. Let me start from but the balance is not showing until I key in the value at cell C4. Now the formula is working the way you are describing. I put in that IF statement so cell C4 would be blank until you inputted a number. Actually most of column C will be blank until you enter a number in a cell in column C. So the next sentence " I prefer to see the value instead of it being empty until I key in the data" , I guess is the confusing part for me. I am assuming when you say value you are referring to column C. Ok so let's drill into this problem by having you add more words to this sentence.

 

[myall_blues]

Thank you for the quick response! The formula is working great but the balance is not showing until I key in the value at cell C4. I prefer to see the value instead of it being empty until I key in the data. I have attached the screenshot. Please help. Thank you

Assuming you want to keep showing the running total, you can just remove the IF function and copy the formula down.

Also you can just sum column C by anchoring (using a $ sign) to the first row.

Book1
	A	B	C	D	E
1	MOM PAYMENT
2	Date	Description	Amount	Total Balance	Remarks
3	3/09/2024	mom paid cash	40000	40000
4			-10000	30000
5			10000	40000
6			10000	50000
7				50000
8				50000
9				50000
10				50000
11				50000
Sheet1

Cell Formulas
Range	Formula
D3:D11	D3	=SUM(C$3:C3)

 

[eazyyexcel]

Assuming you want to keep showing the running total, you can just remove the IF function and copy the formula down.

Also you can just sum column C by anchoring (using a $ sign) to the first row.

Book1
	A	B	C	D	E
1	MOM PAYMENT
2	Date	Description	Amount	Total Balance	Remarks
3	3/09/2024	mom paid cash	40000	40000
4			-10000	30000
5			10000	40000
6			10000	50000
7				50000
8				50000
9				50000
10				50000
11				50000
Sheet1

Cell Formulas
Range	Formula
D3:D11	D3	=SUM(C$3:C3)

Yes this works! Thank you. I wanted the running total to be displayed continuously.

 

[eazyyexcel]

Ok eazy the formula is working. This is a good start. This tells us that the math formula is giving you the amount you are expecting. Now we have to address your next problem or concern. You have attached a screenshot that doesn't really help me understand your problem or concern. And your written description of the problem, is kind of confusing to me. This is not that unusual as most of the time I am always confused. So let me brack down the words. Let me start from but the balance is not showing until I key in the value at cell C4. Now the formula is working the way you are describing. I put in that IF statement so cell C4 would be blank until you inputted a number. Actually most of column C will be blank until you enter a number in a cell in column C. So the next sentence " I prefer to see the value instead of it being empty until I key in the data" , I guess is the confusing part for me. I am assuming when you say value you are referring to column C. Ok so let's drill into this problem by having you add more words to this sentence.

I'm sorry I confused you Ez. I guess my explanation wasn't clear but thanks for your help!

 

[eazyyexcel]

I have another question. I have this excel file saved in my onedrive folder therefore at times I open the file from my onedrive app on my mobile device but at times I open the file from my laptop onedrive folder.

Why is it when I key in the date from my mobile device, I write it as 3/9/24 and I'm following the format of dd/mm/yy but when I view the same file on laptop, the date changes to 9/3/24. How do I make the date consistent no matter if I view the excel file on my mobile device or my laptop? thank you

 

[myall_blues]

Do you have the OneDrive folder synced to your laptop so that you open it from windows explorer, or is it opening in a browser window as a webpage?

 

[eazyyexcel]

Yes the onedrive folder is synced to my laptop. It is like a local file. I don't have my laptop with me right now so I can't send a screenshot. I do not use the onedrive on windows Browser webpage because I feel it works more smoothly and user friendly when the onedrive is synced directly to my local drive. Thanks