PV and Rate function?

[liuec]

Hi, does anyone know what is the Access version of excel function PV and Rate functions?
In excel the PV function has the following syntax: PV( interest_rate, number_payments, payment, FV, Type )
and here's the syntax for Rate function: Rate( number_payments, payment, PV, FV, Type, Estimate )

Thanks so much!

Edit: I'm using Access 2003... if that matters.

 

[stopher]

I don't think there is one in Access. So you have a couple of choices. You can create your own function (Excel help gives you the formula). Or you can reference the Microsoft Excel Object Library and create your own function using the Excel function like this (or just use it straight out the box if you don't need a function):

Public Function PV(Rate As Double, Nper As Double, Pmt As Double, Optional Fv As Variant, Optional pType As Variant)

    PV = Excel.WorksheetFunction.PV(Rate, Nper, Pmt, Fv, pType)

End Function

 

[liuec]

Gotcha, works just as I wanted!

I don't think there is one in Access. So you have a couple of choices. You can create your own function (Excel help gives you the formula). Or you can reference the Microsoft Excel Object Library and create your own function using the Excel function like this (or just use it straight out the box if you don't need a function):

Public Function PV(Rate As Double, Nper As Double, Pmt As Double, Optional Fv As Variant, Optional pType As Variant)

    PV = Excel.WorksheetFunction.PV(Rate, Nper, Pmt, Fv, pType)

End Function