LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 63
Default Need Formula Help... To Hard for me!!! LOL

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
inserting hard CR in a formula Rick Morrison Excel Worksheet Functions 1 November 8th 06 04:51 PM
Hard returns in a formula? PCLIVE Excel Worksheet Functions 5 February 8th 06 05:17 PM
formula won't work unless column of data is a hard number Ron Excel Worksheet Functions 2 May 17th 05 03:21 PM
Is is possible to add a hard return to a merge cell formula? Nmo11 Excel Discussion (Misc queries) 4 April 5th 05 05:47 PM
Excel formula randomly changes to hard-code number Ned Excel Discussion (Misc queries) 3 February 14th 05 11:31 PM


All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"