Suppose one us dollar can be converted to euros, mexican pesos, or yens. the portfolio file contains a list of customers that need dollars to be converted to one of the three below currencies at the respective rates indicated. use excel formulas and functions as appropriate.
a) using the vlookup function for each customer, display the unit value and total value in the converted currency. in particular, how many euros will customer nancy have?
b) use the countif function to determine how many customers have a need to convert to euro currency?
c) use the sumif function to determine the total mexican peso currency necessary to cover the conversions from dollars.
currency conversion
symbol rate
usd 1
euros 0.84
pesos 19.11
yen 109.65
customer # name dollars to? unit value total value
alan 15.00 pesos
11223344 barry 20.00 euros
11335577 corry 100.00 yen
11447810 diane 50.00 pesos
11560043 evan 75.00 euros
11672276 frank 200.00 euros
11784509 harry 5.00 pesos
11896742 ivan 30.00 pesos
12008975 jack 500.00 yen
12121208 kevin 22.00 yen
12233441 larry 10.00 euros
12345674 mary 37.00 yen
12457907 nancy 540.00 euros
12570140 orren 35.00 euros
12682373 paul 45.00 yen
12794606 robert 300.00 yen
12906839 steve 60.00 pesos
13019072 tom 150.00 euros
13131305 uri 30.00 pesos
13243538 victor 200.00 yen