Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 26th 09, 01:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 20
Default FORMULA: calculating an exchange rate

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.

  #2   Report Post  
Old January 26th 09, 01:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 8,856
Default FORMULA: calculating an exchange rate

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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017