Add interest daily to a changing number

[michaelnzha]

Hi. So let's say I have a cell that has a number. This number increases daily by different amounts. What I want to do is to add interest to this number everyday. (interest is a percentage of the number in the cell)

in short I want to calculate and add interest to the "TOTAL" cell daily.

 

[Saurabhj]

Hi,

As per your data, I put simple calculation step. Please confirm what else is required in the calculation?

Book1
	A	B	C	D	E
1	Sales	%	Comission	Debt	Total
2	6455	0.25	1613.75	1415	3028.75
3
Sheet1

Cell Formulas
Range	Formula
C2	C2	=A2*B2
E2	E2	=C2+D2

 

[michaelnzha]

Hi,

As per your data, I put simple calculation step. Please confirm what else is required in the calculation?

Book1
	A	B	C	D	E
1	Sales	%	Comission	Debt	Total
2	6455	0.25	1613.75	1415	3028.75
3
Sheet1

Cell Formulas
Range	Formula
C2	C2	=A2*B2
E2	E2	=C2+D2

I want to calculate how much is the interest for cell E2 and add it to the total. So let's say the interest is 2% daily and amount is 3028. Then it'd calculate 3028 x 0.02. And add the result to the total daily.