View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Need Formula Help... To Hard for me!!! LOL

Well, in order to "hide" the errors, you could put a conditional format on
the subsequent days entry row something like this:

Select the cells in the row of interest
Let's assume you are doing this for Row 3


Format - Conditional Formula
Formula is =isblank($B3) '<~~~change to match the cells you need.
Change the font color to be the same color as the background.
--
HTH,
Barb Reinhardt



"j5b9721" wrote:

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