Hi,
I would like to know how I can calculate a rate of local currency into USD based in the time period and country in 1 formula.
It is hard to explain what I want to do but looking at the attached file might be helpful, column F contains the final outcome I want in the formula.
Thank you in advance excel experts.
-D2S
Bookmarks