![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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. |
| Ads |
|
#2
|
|||
|
|||
|
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 On Jan 26, 1:18*pm, Shevvie > wrote: > 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. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create a Exchange Currency Rate into Excel | Blue Fish[_2_] | Excel Worksheet Functions | 3 | May 30th 08 12:30 PM |
| euro-sterling exchange rate | Roger on Excel | Excel Discussion (Misc queries) | 2 | November 25th 07 02:52 PM |
| vlookup for exchange rate | Gábor | Excel Worksheet Functions | 2 | July 21st 06 09:41 PM |
| Calculating Month Average Exch Rate from Exchange Rates Calendar!!! | StanUkr | Excel Worksheet Functions | 0 | September 14th 05 11:12 AM |
| how to calculate exchange rate? | papa404 | Excel Discussion (Misc queries) | 2 | August 2nd 05 01:43 PM |