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
|