Equivalent of Lotus 123 PVAmount

R

RAK

I am attempting to convert a Lotus 123 spreadsheet to
EXCEL and can not convert the Lotus PVAmount financial
function to excel. The PV and NPV functions do not
return the same values.

Any thoughts?
 
T

Tushar Mehta

123's @PVAMOUNT function is a pure convenience function, meaning it serves
no vital purpose.

@PVAMOUNT(FV,Rate,NPer,Freq) = FV/(1+Rate/Freq)^(NPer*Freq)
Click to expand...
OK, so the XL PV function with PMT=0 and FV=<whatever> will yield the
same result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lotus 123 @nsum function equivalent in excel(?) 10
How can I use circular references that are allowed in Lotus 123? 1
Does Excel have a @grandtotal function like Lotus 123 2
how to convert Lotus 123 to Excel directly and can running normal 1
Using "OR" in an IF statement 6
assign a macro to send email in lotus notes from Excel spreadsheet 0
Xindex 2
SaveAs wk3 file type error message 1

Top