compounding

[tom donino]

what function is best for a compounding formula where I
want to calculate the expected balance of amount in cell
a1 at interest rate in cell b1 over term in cell c1 in
years?

 

[mangesh_yadav]

I don't think there is any ready-made function (unless I have misse
it). But you can use the following formula for your example above.

=A1*(1+B1)^C1

Manges

 

[Fred Smith]

The function is FV, as in:

=FV(b1,c1,0,a1)