G
Guest
hOW CAN i EXTRACT THE EXCHANGE RATE BASED ON CURRENCY AND MONTH?
Here is the example:
EXCHANGE RATES
Currency JAN FEB MAR APR
Belize 0.5076 0.5076 0.5076 0.5076
BP 1.7500 1.7700 1.7800 1.8000
Ca$ 0.7000 0.7000 0.7000 0.7000
CH 0.9000 0.9000 0.9000 0.9000
Euro 1.2700 1.3000 1.3200 1.4000
Honduras 0.0554 0.0555 0.0556 0.0557
Nicaragua 0.0667 0.0665 0.0667 0.0665
USD 1.0000 1.0000 1.0000 1.0000
____________________________________________________
Item Month Currency Lcl Currency Amount in USD
Chocolate JAN Euro 100 Formula?????
Flowers FEB Honduras 1500 Formula?????
Petrol JAN Belize 250 Formula?????
Here is the example:
EXCHANGE RATES
Currency JAN FEB MAR APR
Belize 0.5076 0.5076 0.5076 0.5076
BP 1.7500 1.7700 1.7800 1.8000
Ca$ 0.7000 0.7000 0.7000 0.7000
CH 0.9000 0.9000 0.9000 0.9000
Euro 1.2700 1.3000 1.3200 1.4000
Honduras 0.0554 0.0555 0.0556 0.0557
Nicaragua 0.0667 0.0665 0.0667 0.0665
USD 1.0000 1.0000 1.0000 1.0000
____________________________________________________
Item Month Currency Lcl Currency Amount in USD
Chocolate JAN Euro 100 Formula?????
Flowers FEB Honduras 1500 Formula?????
Petrol JAN Belize 250 Formula?????