J
j5b9721
Is there a formula that I can use to compound interest daily like this?
(A1) (B1) (C1) (D1) (E1)
Total
Average
Capital Todays Days 100% Compounded Daily
Rate Daily Interest Interest
1000 .012 240 16511.49 =D1/240
I dont know if this is correct for (D1) Total.
_______________________________________________________
Then I need it this way also...
(A) (B) (C) (D)
Daily
1 Capital Todays Days Interest
Rate
2 1000 calulated 240 Entered daily
daily
3 =A1+D1 (same) =C1-1 (same)
But I looking for no errors in the cells... until the next day is
entered in D2 & D3.
Thanks for your time!!!
Joe
(A1) (B1) (C1) (D1) (E1)
Total
Average
Capital Todays Days 100% Compounded Daily
Rate Daily Interest Interest
1000 .012 240 16511.49 =D1/240
I dont know if this is correct for (D1) Total.
_______________________________________________________
Then I need it this way also...
(A) (B) (C) (D)
Daily
1 Capital Todays Days Interest
Rate
2 1000 calulated 240 Entered daily
daily
3 =A1+D1 (same) =C1-1 (same)
But I looking for no errors in the cells... until the next day is
entered in D2 & D3.
Thanks for your time!!!
Joe