View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier David Billigmeier is offline
external usenet poster
 
Posts: 176
Default How to do a Linear interpolation in excel?

Assuming the discount factors follow a linear pattern relative to the dates
you can use:

=FORECAST(<new date,<range of discount factors,<range of corresponding
dates)

--
Regards,
Dave


"Ines" wrote:

I need to find a function that permites me to create a rule for linear
interpolation for virtually any point given an array of dates and discount
factors. For a given date how can I calculate the aproximate discount factor?