Hello,

Can you please provide the excel formula for the below problem?

Thank you,

In cell G12, look up and display the exchange rate for this transaction from the Currency Conversion Table. In cell H12, lookup and display the currency code for this transaction from the Currency conversion table. If cell H4 is blank, cell G12 should also be blank.

Currency Converter

Country Visiting

Australia

U.S. Dollars Received

$1,000.00

Less: Conversion Fee

$30.00

U.S. Dollars Converted

$970.00

Converted to:

1,299.80

Currency Conversion Table
Country Visiting	Currency Name	$1 U.S. Equals	Currency Code
Australia	Australian dollar	$1.34	AUD
Brazil	Bazilian Real	$3.26	BRL
Britain	British Pound	$0.78	GBP
Canada	Canadian Dollar	$1.35	CAD
China	Chinese Yuan Renminbi	$6.86	CYN
Europe	Euro	$0.90	EUR
Hong Kong	Hong Kong Dollar	$7.79	HKD
Japan	Japanese Yen	$111.17	JPY
Mexico	Mexican Peso	$18.51	MXN
Russia	Russian Ruble	$56.51	RUB
Singapore	Singapore Dollar	$1.39	SGD
Switzerland	Swiss Franc	$0.98	CHF
Conversion fee	3.0%
Minimum charge	$5.00