[Solved] FORECASTING FORMULARS

[mnor001]

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

 

[Yousuf Shovon]

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.

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