Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
inserting hard CR in a formula | Excel Worksheet Functions | |||
Hard returns in a formula? | Excel Worksheet Functions | |||
formula won't work unless column of data is a hard number | Excel Worksheet Functions | |||
Is is possible to add a hard return to a merge cell formula? | Excel Discussion (Misc queries) | |||
Excel formula randomly changes to hard-code number | Excel Discussion (Misc queries) |