what is the formula from british pounds to American dollars

M

MAMAITO

I am trying to set up an expense reports that converts pounds to dollars
I need the formula for it can anyone help?

Thanks
 
D

Dave

Mamaito

The exchange rate from British Pounds to American dollars is volotile. You
can check the exchange rate at
http://www.oanda.com/convert/fxhistory
right now it is 1.86704. Therefore if your american dollar value is in A1
and you want your result in B1. Enter =A1*1.86704 in cell B1. It may be
better to enter the exchange rate in a cell

Dave
 

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
Template Req. Monthly Budgeting. British Pounds only. Thanks 1
Does anyone have a template to convert Kilos to Pounds & Ounces 4
My spreadsheet is formatted to British pounds, need US dollars 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Need Help Creating a Macro to Multiply Cells by a Constant Number 5
How do I format a cell to show weight in stones and pounds? 2
Dumb question alert! What program to use? 0

Top