Use the FV function: =-FV(5%,3,250) will tell you the value after the 3rd
event.

"Nick" wrote:

I'm looking for a formula that will replace a look up table. I have a base
amount of $250 that increases 5% with each event (compounded) such that the
first event is $250, second event is $512.50, then $788.13, etc. Is there a
financial (or other) function that would tell me the total amount of the xth
event?
--
Thanks,
Nick