FORMULA: calculating an exchange rate

S

Shevvie

I need to be sure I am calculating an exchange rate correctly - using today's
exchange rate for Dollar and Pound, what would be the cell formula to
calculate, below:

USD GBP Exchange Rate
750 543.44 0.72406

Also, would you know of a website that can help with other formulas such as
timezone differences ie. enter UK/Burbank CA = GMT timezone /-8hrs ?

Thank you - appreciate any help you can offer.
 
P

Pete_UK

In your example, rate = 543.44 / 750 which equals 0.72459 on my
calculator. As an Excel formula in C2:

=B2/A2

To subtract 8 hours from a time in A10:

=A10 - 8/24

as times are stored as fractions of a 24-hour day.

Hope this helps.

Pete
 

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

convert to GBP - formula to identify 1st character and Acc type 2
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! 0
Calculating an Implied Interest Rate 0
Custom field formula to evaluate a flag, and then calculate a rate 5
Formula problem 3
Need an Excel formula 2
A Macro to autofind a value in a range 5
Toggle box and its use in a formula 9

Top