convert dollars to pounds using a lookup formula

B

Bob Phillips

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)
 
G

Guest

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:
 
G

Guest

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
How do I use Excel to convert UK pounds to US dollars? 1
what is the formula from british pounds to American dollars 1
IF formula for currency or Macro help. 0
need a formula to convert pounds to tons( 2000) lbs per ton 4
how do I create a formula to convert kilograms to pounds 4
Convert Numbers to Words for UK format 0
Pounds & Ounces 14

Top