XNPV might do the trick. Look it up in help...
--
HTH...

Jim Thomlinson


"Goalpost" wrote:

Is there an excel function that will calculate a current value of past
payments which were dissimilar in amount and time (diff payment amounts
occuring at various times)?