S
Sharon
Hello,
I am trying to use a lookup function to calculate the following:
To determine the amount of foreign currency due a custorm
My Excel looks like this:
Columns A & B
Country traveling to: England
US Dollars to exchange: $1,000.00
Country's currency: Pound
Amount due customer:
Columns D, E, & F
Country Currency Exchange Rate
England Pound 0.6200
France Euro 0.9525
Germany Euro 0.9526
Canada Dollar 1.5603
How do I set up the calculation to calculate the foreign currency the
customer is due and that this figure appears in cell B8 labeled "Amount due
customer". The first one shoulw list $620, but my lookup function gives me
#N/A...please hlep
I am trying to use a lookup function to calculate the following:
To determine the amount of foreign currency due a custorm
My Excel looks like this:
Columns A & B
Country traveling to: England
US Dollars to exchange: $1,000.00
Country's currency: Pound
Amount due customer:
Columns D, E, & F
Country Currency Exchange Rate
England Pound 0.6200
France Euro 0.9525
Germany Euro 0.9526
Canada Dollar 1.5603
How do I set up the calculation to calculate the foreign currency the
customer is due and that this figure appears in cell B8 labeled "Amount due
customer". The first one shoulw list $620, but my lookup function gives me
#N/A...please hlep