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

Marcelo

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

cuffie

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

Mail Merge Switch - Dollars to Words 0
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
¿How to divide a total into 0
pounds shillings pence format in excel 2
need a formula to convert pounds to tons( 2000) lbs per ton 4
How do I convert pounds to stones eg 200 pounds is 14 stone 4 lb 4

Top