View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default PV function conversion to SQL

Does anyone know what the corresponding sql code woudl be of the
excel PV function -

In excel function PV the inputs are PV («rate», «nper», «pmt»,
«fv»,
«due») where rate = discount rate, nper = number of payments, pmt =
payment) other two are not required.


nper is allowed to be a number with decimals, not just an integer.


I am seeking the sql code which will replicate the above, including
nper with
decimals allowed. Thanks.