Can't create formula for interest with intermittent growing capital

[Ochimus]

As shown on attached, Day1 starts with £100 investment earning 1% interest per day.

Every time interest exceeds £10, that £10 (or multiples of it) is added to capital, which therefore increases the daily interest. Anything less than £10 is added to wallet but does not attract investment, being used solely to build next £10 stake.

Can't see formula that will allow me to enter an opening value (e.g. £100), interest rate (e.g.1%) and number of days (e.g. 164), that will then calculate each "interim" increase to reach the final value of £620 invested and £6.80 in the trading wallet

As ever, any suggestions, pointers or solutions accepted gratefully

Ochimus

[tim201110]

What about Surplus?

[tim201110]

I can't see a solution with worksheetfunctions
just UDF

Please Login or Register  to view this content.

in E5 should be =E4*(F4=0)+G4+D5 and pull down