Sory... the formula in Z100 is the total interest
--
Gary''s Student - gsnu200785


"David Brereton" wrote:

HELP please. I have looked through all possible formulae but cannot find one
to suit.
I am trying to find an easy / short way to calculate interest on a debt ,
but compounded on a daily basis.
The info I will have will be :-
1. Amount of debt
2. Start date of debt
3. Date to which interest is to be calculated to
4. Interest rate ( fixed )

How can I create a formulae to calculate this in one swoop ?