Die Opgelope () funksie gee terug Die waarde van 'n belegging, gegewe Die primêre, nominaal belang tempo, opgehope frekwensie en tyd. Vir voorbeeld: $5000 na 12% belang opgehope kwartaliks Vir 5 jare sal word Opgelope( 5000; 0. 12; 4; 5) of $9030. 56.
The COMPOUND() function returns the value of an investment, given the principal, nominal interest rate, compounding frequency and time. For example: $5000 at 12% interest compounded quarterly for 5 years will become COMPOUND(5000; 0.12; 4; 5) or $9030.56.