[Solved] FORECASTING FORMULARS

mnor001

New member
How do i forecast the future exchange rate given one month exchange rate to forecast the next 9 mths rates
 

Attachments

  • INTERBANK RATES FORECAST.xlsx
    14.6 KB · Views: 2
How do i forecast the future exchange rate given one month exchange rate to forecast the next 9 mths rates
Hello Mnor001,

Welcome to the ExcelDemy forum! From the given post, I understand you wish to forecast the exchange rates for the next 9 months.

Fortunately, you can do that in 3 ways using the FORECAST function, the Forecast Sheet feature, and through VBA code. In this case, utilizing the function shows more accurate predictions. Let's go through some easy steps to implement this.

  • In E26, type the following formula and press Enter.
=FORECAST(A26,E3:E25,A3:A25)
  • Afterward, drag the AutoFill hand down or double-click on it to obtain the desired rates.
FORECAST Function-1.png

For the VBA method, go to https://www.exceldemy.com/excel-vba-forecast-function/.

I have attached the Excel file for better understanding. I hope this works for you. Good luck!!

Regards,
Yousuf Shovon
 

Attachments

  • INTERBANK RATES FORECAST.xlsx
    20.3 KB · Views: 4
Last edited:

Online statistics

Members online
0
Guests online
10
Total visitors
10

Forum statistics

Threads
287
Messages
1,240
Members
508
Latest member
HaroldDyeme
Top