how to calculate exchange rate?

Please I need a formulea to calculate Country exchange rate?
Many thanks
papa404 (1)
8/1/2005 8:13:02 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 15

Question is a bit  vague... If you just want a formula to say convert $10 
(In A1) to  �GBP (In B1) at a rate of 1.8 �/$ then in Cell B1 enter


You can put the exchange rate in say C1 and always refer to that, so it's 
easy to change


or is you have a series of currencies with say currency codes in a table 
with their exchange rates then you should consider looking at VLOOKUP in 

If you need more help. post back with more info

Nick Hodge
Microsoft MVP - Excel
Southampton, England

"papa404" <> wrote in message
> Please I need a formulea to calculate Country exchange rate?
> Many thanks 

8/1/2005 8:31:22 PM
On Mon, 1 Aug 2005 13:13:02 -0700 in article <12CE93FD-52A9-4B84-9D48->, spoke 
> Please I need a formulea to calculate Country exchange rate?
> Many thanks
Exchange rates cannot be calculated by Excel. The banks doing business with 
another country calculates the exchange rate and they change daily. So if 
country A is doing business with country B, country A's banks calculate the 
exchange rate for the day with country B. 

Sig: Say no to fixed width HTML tables. They look terrible in most browsers.
cs469 (7)
8/2/2005 12:43:20 PM

Similar Artilces:

Exchange DoS vulnerability due to possible named properties overflow
Hello All, Here's a problem. Exchange Server 2003 has a hard quota limit for the named properties of the messages stored in Exchange Information store, as described in a KB article 820379. After the quota has been reached, numerous error messages with Event ID 9667 and 12800 from MSExchangeIS are generated in Exchange server's Application Log. This creates DoS conditions for the affected Information store. If the quota is increased up to the capacity limit of the named properties table (32,000), server can become unresponsive to client requests. Named properties quota overflow can be...

Calculating Taxes and Making calculations
Hello, Kindly plz tell me how do i go about making some small calculations based on my existing data such as how to compute taxes and do other calculations based on some quantitative data. where exactly do i make modifications on my application??? Kindly help me out. Thanks , swati you can add code in javascript behind dropdowns or piclist fields. One example might be a dropdown which has shipping options ie ups, fedex etc. When you choose one it takes the weight of your package (whcih you enter) then calculates a shipping cost. search the archives of this group at and ...

Procedure to calculate distance using latitude/longitude
Does anyone know of a vba procedure for access that will calculate straightline distance using latitude and logitude for 2 points? AJ wrote: > Does anyone know of a vba procedure for access that will calculate > straightline distance using latitude and logitude for 2 points? See: James A. Fortune ...

Using OWA from another Exchange Server
Hi Guys! We have 2 Exchange Servers in the same organization, EXCH1 and EXCH2,OWA is enabled on EXCH1. Both servers have mailboxes. The question is how do I configure users on EXCH2 to logon to their mailboxes using the OWA running on EXCH1.Your response will be most appreciated. We run Exchange Server 2003 SP1 on Windows Server 2003 SP1 -- Buchi "Buchi" <> wrote in message > Hi Guys! > We have 2 Exchange Servers in the same organization, EXCH1 and EXCH2,OWA > is > en...

How to calculate age of a person?
Hi, I'm struggling to figure this one out. I have a date column and I'd like to be able to calculate the age without doing it in my head. I've tried to do this but am struggling. Any help will greatly appreciated. Thanks Suzanne Visit and search for DATEDIFF best wishes -- Bernard V Liengme Microsoft Excel MVP remove caps from email "Grd" <> wrote in message > Hi, > > I'm struggling to figure this one out. I have...

Removing Exchange Server from AD
So I had a server die and restored the data to another server with a different name. Now I have an orphaned server in ESM. Can I completely remove it from AD simply by right-clicking it and selecting 'Remove Server'? Or do I have to go using ADSI Edit to clean it up? Run with setup with /removeorg. How to completely remove a Exchange server or the entire Exchange organization James Chong (MVP) MCSE | M+, S+, MCTS, Security+ On Mar 13, 4:11 pm, Mark Dola...

EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge
I am trying to calculate monthly INTEREST ONLY payment on a short term bridge/swing loan. Assuming an interest rate of 2.75%, paid monthly, Also assuming it will be required for a 3-6 month period, amount approx $500,000. Just switched to Excel 2007 but don't seem to be able to calculate using the formula builder. Not sure if it is compounded daily or monthly. You might want to check out the IPMT function. From the XL help file: IPMT(rate,per,nper,pv,fv,type) Rate is the interest rate per period. Per is the period for which you want to find the interest and must...

Can Outlook access Exchange Servers over the Internet?
I have multiple Email accounts located on different Exchange Servers (different locations). I want to know if there is an add-on for Outlook, in order to access multiple Exchange Servers over the Internet instead of using the Outlook WEB page. Thanks for any help, VPN will let you do this. You need to ask the Admins at the places where you access Outlook via Exchange for the credentials and the specific client. You will also need to set up separate profiles for each Exchange account that you want to access. How VPN works with multiple profiles/exchange accounts, I do not know. --� Mil...

HELP, How do I share Outlook folders on a local network WITHOUT Exchange server??
If you're talking about Personal Folders in Outlook (PST files), the best thing I can suggest is to locate the folder where the PST file is stored on the host machine, share that folder, and map to that folder from the other PC. Then add the remotely shared PST file to the Outlook profle (accessing the shared file on your network) .. >-----Original Message----- > >. > Unfortunately, Outlook requires exclusive access to PST files, so only one person can have Outlook open to access that file at any time. A good place to start looking for other solutions would be: http:/...

Due Date Calculated
I need assistance on an expression that allows for the due date of recurring training to be one year from date completed. Details are as follows: I have a form named [frmTRNComplete] based on table named [tblTRNComplete] Form controls are: TRNID (combo box), DateComp (Text Box) , DateNext (text box), Reccuring (check box) I would like the DateNext to be 1 year from DateComp if Reccuring is true and Date next to be blank if Reccuring is false. -- Aloha, Ron A. Ron I'll assume that you want to use the form to calculate the DateNext, and that you are not trying to s...

Outlook fails to connect to exchange every second day.
Hi, I have a client who uses exchange and asked about a bizzare behaviour they have been experiencing. Apparently every (approximate) two days when they come into the office their outlook will fail to connect to exchange. What they have been doing to fix this is to Reboot exchange. For some reason this is working. What I am hoping to find is a "fix" that doens't require a reboot. :) There seems to be an error in the event log indicating that the exchange database is larger than it is allowed to be. Could this cause the experience they are seeing? Any clu...

Question about installing the CRM-Exchange E-mail Router on Exchange server with Mail Essentials anti-spammer installed
Getting ready to install the CRM-Exchange e-mail router on my Exchange 2000 Server. We also happen to have the Mail Essentials Anti-Spam software installed on this exchange server. Does anyone know of any negative interactions or anything I need to be aware of before installing the E-mail router? Thanks for the response! -Dave Vandenberghe We too are using third-party anti-spam software on our Exchange 2K server and it hasn't had any conflict with the Email Router for CRM. -Gary "Dave Vandenberghe" <> wrote in message ne...

how to calculate outliers
Google is your friend: - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - _______ "ismhs" <> wrote in message > ...

Calculated field options???
Here's my Data: Country Status --------- ---------- Canada Green Canada Blue Canada Green Canada Green Canada Blue In my pivot table, 'Country' is an item, and 'Status' is my only data field. What I really need to show in my data area is two column of data, one for 'Green' and one for 'Blue'. I tried creating two 'Calculated' fields with the following formulas, but they don't seem to be working: 'CalculatedField1' = IF((STATUS="Green"),1,0) 'CalculatedF...

Real strange symptom.. Big Exchange bug of 2005?
Current setup: Exchange SBS 2003, Outlook 2003 Setup date: around Sept this year Hi all, i face a really really strange situation. I have some rules setup already to put dedicate user, e.g., Michael Jordan, to a folder "Jordan". Therules work well that put email from MJ to folder Jordan but today i found 3 emails from MJ sent few days before is not work. Instantly i trigger the rule manually "Run rule now" so that the email from MJ put back to folder "Jordan" although i m not sure why email does not follow the rule. BUT, the strange is, even i "Run rule now...

tenure calculations
how can I format several dates such as 04/19/2003, 04/01/2004, etc. int a yearly average for the employee tenure -- Message posted from right now say I have my yearly figures in i1-i9. The formula I though would work is =today()-average(i1:i9), but how would i format this to give me yearly read out -- Message posted from Hi djackson! One way is to use YEARFRAC with a third argument of 1 to get your tenures in years and fractions of a year and then average the result. However YEARFRAC does produce some annoying but small errors. Y...

Time Sheet Function to Calculate
I am having some trouble trying to establish a formula that will give me the number of hours worked during the day given the start time say 8.30am with an end time of 5.30pm and say 30 minutes for lunch. For this scenario, total working hours would be eight and a half hours but I need Excel to display this result as 8.30 hours (0.30 being the minutes in the half hour) and not 8.50. Can someone suggest what to do? Typically the layout would be Column A - Start Time say 8.30am Column B - Time in minutes spent at lunch say 30 minutes Column C - End Time say 5.30pm. Column D - the calculati...

Self Service Administration for Exchange ...

Formula to calculate time
I was wondering if anybody knows of a formula to allow you to do calculations based on time. In other words, say I want to put a list of songs on a CD and their durations. Then, I want to add up the durations to get the full time of the CD, or my specific play list. So for example, using the information below: Ghostbusters - Ray Parker Jr. --- 5:23 (Just a guess) Phantom of the Opera Overture --- 3:55 (Another guess) Instead of 8:78, I'd want to see 9:18 Can this be done? Any help would be greatly appreciated. Thank you! -- Have a nice day! ~Paul Express Scripts, Charting the futu...

Exchange 2003 SBS And Outlook 2003
Hello We have the public folders in Exchange setup to except mail from the outside world, and what we are noticing that when mail is delivered to the folder it shows as a post. What we want is to make it act as an email, so when we reply to it we can reply to all of the original recipients. Any help would be greatly appreciated. Oh also one more question. When we add a new user to the exchange server, we can not add that acct to the persons outlook unless we restart the exchange services. Thanks In, Exchange 2003 <Exchang...

Migrate from POP3 to Exchange 2003
Our clients have decided to migrate from a POP3 with a pst using Outlook to Exchange 2003. How should I go about this...can their psts be ExMerged directly into the new Ex03 server or does this have to be done manually, client by client? Thanks! On Wed, 29 Sep 2004 12:37:31 -0700, "Heather" <> wrote: >Our clients have decided to migrate from a POP3 with a >pst using Outlook to Exchange 2003. > >How should I go about this...can their psts be ExMerged >directly into the new Ex03 server or does this have to be >don...

Insert calculated median field in pivottable
Anyone know how to get a median calculation in a pivot table? I've tried inserting a calculated field but it always sums the calculated field. Thanks, Joel Not supported in a pivot -- Regards, Peo Sjoblom (No private emails please) "Joel Schaefer" <> wrote in message news:ev4P0Nk6FHA.2616@TK2MSFTNGP15.phx.gbl... > Anyone know how to get a median calculation in a pivot table? I've tried > inserting a calculated field but it always sums the calculated field. > > Thanks, > > Joel > ...

Exchange 2000 Orphaned Mailbox?
I have an executive's secretary that recently retired. She was setup in Active Directory/exchange to receive copies of all of his emails. She was replaced by a new secretary and I changed Active Directory/exchange to reflect that the new secretary should get copies of his emails. I deleted the old secretaries account from Active Directory, and answered yes to deleting her mailbox. Now, when someone sends an email to the executive, the new secretary gets a copy, the executive gets a copy and the sender gets a response that the old secretary isn't a valid mailbox. ANy suggest...

Javascript help, calculation whoes when calculating from a calculation....
I am having a strange issue with Javascript and I cannot see what the issue us? Essentially I need to be able to calculate two values, one is addition and the second is multiplication. I am getting some strange numbers. My code is at the bottom under the ------, here are the details. crmForm.all.estimatedvalue.DataValue = 10 crmForm.all.new_cfp_estrev_nextyr.DataValue = 10 crmForm.all.new_cfp_estrev_yrtwoplus.DataValue = 10 This should make totalestrev = 30, Then its getting weird, I am taking the following formula (10/100)*30 = 270? Here 10 is the value selected from the drop down value, I ...

calculator errors
when i enter an equation into a cell such as: =product(a1,b1) into cell c1. If a1 is 1000 and b1 is .10 than c1 should equal 100, but it equals 102.04. My calculator is off somehow when i try to multiply. Please help me. Thank You, Kat I'd take a look at the values in A1 and B1. Are they really 1000 and .10 or are they 1000.49999 or .10444 (for example) "Kat and the Calculator" <> wrote in message > when i enter an equation into a cell such as: =product(a...