convert dollars to pounds using a lookup formula

  • Thread starter Thread starter Guest
  • Start date Start date
You don't need a lookup formula, just store the exchange rate somewhere, and
multiply by that rate.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
hi,

did you looking for a date in a fxrate table to find the rate?


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"cuffie" escreveu:
 
I have to have a lookup formula for "Amount Due Customer so every time I
change country and dollars to exchange it give me the amount due.


Column A
Transaction Data: Country Currency
Exchange Rate
Country Traveling: England England Pound
0.62
US Dollars to Exchange: $1,000.00 France Euro
0.9525
Country's Currency: Pound
Amout due Customer:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Pounfs to US Dollars 3
what is the formula from british pounds to American dollars 1
How do I use Excel to convert UK pounds to US dollars? 1
Multiple variable lookup tables 3
Lookup Functions 6
CONCATENATE & LOOKUP Functions 0
IF formula for currency or Macro help. 0
need a formula to convert pounds to tons( 2000) lbs per ton 4

Back
Top