Converting Local Currency to USD

tomtingley

Hi,

I'm trying to convert my data from local currency into US Dollars using FX rates below

My FX rates are quarterly, so I would want Jan24, Feb24 and Mar24 to be converted using the Q1 FX Rate and Apr24, May24, Jun24 with the Q2 rate, etc.

Is anyone able to help?

The currency I am converting from is in the 'Currency Column'. For example, Property A is in ZAR and Property B is in CHF.

FX Rates per quarter

ZAR - 0.055, 0.055, 0.054, 0.053

GBP - 1.163, 1.162, 1.161, 1.049

CHF - 1.072, 1.078, 1.084, 1.090

Script591.xlsx

ShankerV

Hi @tomtingley 

Step 1: Input.

Step 2:

Step 3: 

Step 4: 

IF [Name] = "Jan - 2024" or [Name] = "Feb - 2024" or [Name]="Mar - 2024"
THEN 2
ELSEIF [Name] = "Apr - 2024" or [Name] = "May - 2024" or [Name]="Jun - 2024"
THEN 3
ELSEIF [Name] = "Jul - 2024" or [Name] = "Aug - 2024" or [Name]="Sep - 2024"
THEN 4
ELSE 5
ENDIF

Step 5:  Input of Fx

Step 6: 

Step 7:

Step 8:

Step 9:

Step 10:

Last step:

Many thanks

Shanker V