Spreadsheet: 494081d1482165371-data-validation-book1
Sheet: TRANSFERS_USD

HONG KONG TRANSFERS |  |  |  |  |  |  |  |  | 7.7
Validity unless otherwise stated is from 01 April 2017 - 31 March 2018
Hong Kong | Currency | AIR-CONDITIONED CAR / MPV / COACH
 |  | [1] | [2] | [3] | [4] | (5-9) | SIV#
TRANSFERS
AIRPORT TRANSFERS
[NAME] to downtown hotels in Kowloon or v.v. | HKD | 98.7012987012987 | 50 | 47.14285714285714 | 38.57142857142857 | 36.88311688311688 | 23.37662337662337 | how can I change the amount when the currency is not HKCD
[NAME] to downtown hotels in Hong Kong or v.v. | USD | 110.3896103896104 | 58.05194805194805 | 52.33766233766234 | 42.5974025974026 | 40.90909090909091 | 24.02597402597403
[NAME] to downtown hotels in Tseung Kwan O (Junk Bay) or v.v. | USD | 106.4935064935065 | 54.02597402597402 | 49.61038961038961 | 40.51948051948052 | 39.61038961038961 | N/A | How would I make the following formula in C8
[NAME] to downtown hotels in New Territories or v.v. | USD | 110.3896103896104 | 58.05194805194805 | 52.33766233766234 | 44.02597402597402 | 42.5974025974026 | N/A
[NAME] to Ocean Terminal or v.v. | USD | 114.2857142857143 | 58.83116883116883 | 53.11688311688312 | 44.54545454545455 | 42.98701298701299 | N/A | =IF(B8="HKD",C8*J1,)
[NAME] to Kai Tak Cruise Terminal or v.v. | USD | 124.6753246753247 | 62.33766233766234 | 54.54545454545455 | 42.85714285714285 | 45.45454545454545 | N/A
[NAME] to Macau Ferry Terminal / Train Station or v.v. | USD | 115.5844155844156 | 60.77922077922078 | 54.28571428571428 | 45.06493506493506 | 41.81818181818182 | N/A
[NAME] to Disneyland / Disneyland Hotel or Hollywood Hotel or v.v. | USD | 99.35064935064935 | 50.90909090909091 | 47.53246753246753 | 39.09090909090909 | 38.57142857142857 | N/A
CRUISE TERMINAL TRANSFERS
Ocean Terminal  to downtown hotel in Kowloon or v.v. | USD | 97.4025974025974 | 50.25974025974026 | 45.06493506493506 | 36.23376623376623 | 34.8051948051948 | N/A
Ocean Terminal to downtown hotel in Hong Kong or v.v. | USD | 107.1428571428571 | 55.19480519480519 | 49.48051948051948 | 39.48051948051948 | 37.92207792207792 | N/A
[NAME] to downtown hotel in Kowloon or v.v. | USD | 120.7792207792208 | 58.44155844155844 | 51.94805194805195 | 40.25974025974026 | 42.20779220779221 | N/A
[NAME] to downtown hotel in Hong Kong or v.v. | USD | 123.3766233766234 | 59.74025974025974 | 53.24675324675324 | 42.20779220779221 | 43.50649350649351 | N/A
DOWNTOWN TRANSFERS
Downtown hotels in Kowloon to downtown hotel in Kowloon or v.v. | USD | 70.9090909090909 | 36.88311688311688 | 31.16883116883117 | 27.53246753246753 | 25.97402597402597 | N/A
Downtown hotels in Hong Kong to downtown hotel in Hong Kong or v.v. | USD | 75.06493506493506 | 39.61038961038961 | 33.63636363636363 | 29.61038961038961 | 27.92207792207792 | N/A
Downtown hotels in Kowloon to downtown hotel in Hong Kong or v.v. | USD | 83.11688311688312 | 42.98701298701299 | 37.27272727272727 | 33.76623376623377 | 32.20779220779221 | N/A
Train Station to downtown hotel in Kowloon or v.v. | USD | 92.85714285714286 | 49.09090909090909 | 42.85714285714285 | 33.76623376623377 | 32.20779220779221 | N/A
Train Station to downtown hotel in Hong Kong or v.v. | USD | 96.88311688311688 | 51.16883116883117 | 44.93506493506494 | 35.97402597402597 | 34.02597402597402 | N/A
Macau Ferry Terminal to downtown hotel in Kowloon or v.v. | USD | 98.05194805194805 | 51.81818181818182 | 45.19480519480519 | 36.23376623376623 | 34.41558441558441 | N/A
Macau Ferry Terminal to downtown hotel in Hong Kong or v.v. | USD | 95.45454545454545 | 50.51948051948052 | 44.54545454545455 | 35.45454545454545 | 33.11688311688312 | N/A
Downtown hotel in Kowloon to Disneyland / Disneyland Hotel or Hollywood Hotel or v.v. | USD | 99.35064935064935 | 50.90909090909091 | 47.53246753246753 | 39.09090909090909 | 38.57142857142857 | N/A
Downtown hotel in Hong Kong to Disneyland / Disneyland Hotel or Hollywood Hotel or v.v. | USD | 110.5194805194805 | 58.05194805194805 | 52.33766233766234 | 42.5974025974026 | 40.90909090909091 | N/A