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.
Afterward, drag the AutoFill hand down or double-click on it to obtain the desired rates.