+ Reply to Thread
Results 1 to 2 of 2

Exchange Rate Fluctuation Adjustment Calculation

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    canada
    MS-Off Ver
    Windows
    Posts
    20

    Exchange Rate Fluctuation Adjustment Calculation

    By no means am I an Excel guru but I am curious to know if this is possible within excel.

    Reason we are a Canadian Dealer and a lot of our suppliers are south of the 49th and we deal with exchange rates on a daily basis.

    How do you compute this equation below in excel?

    TIA

    Adjustment = FCC x Qty x ( i1 - i0 ) / i0
    where formula variables correspond to:
    FCC Foreign Currency Component (per unit)
    i0
    Initial exchange rate (CAN$ per unit of foreign currency [e.g. US$1])
    i1
    exchange rate for adjustments (CAN$ per unit of foreign currency [e.g. US$1])
    Qty quantity of units

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Exchange Rate Fluctuation Adjustment Calculation

    Okay, I think this is still unanswered because everyone is unsure of what you are really asking. You state you are not a guru, but your question, as described, seems to be very basic. So basic, that I think people are hesitating in answering for fear that (a) this devolves into an 'Excel for Dummies' discussion (in which case, just get a book or read the many tutorials on line), or (b) there is more to it than meets the eye (e.g. you are looking for a way to automatically grab the latest exchange rates from a website).
    So, let me answer it at the basic level and see where this goes...

    Yes, excel can certainly perform that calculation. Let's say you have the FCC in cell A1, i0 in cell B1, i1 in cell C1, and Qty in cell D1. In cell E1, you can type:
    =A1*D1*(C1-B1)/B1
    to get your adjustment.
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Rate exchange help
    By bazgau in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-14-2012, 02:26 PM
  2. IF exchange rate
    By bjelinski in forum Excel General
    Replies: 4
    Last Post: 09-15-2010, 04:24 AM
  3. Exchange Rate calculation
    By vaibz in forum Excel General
    Replies: 2
    Last Post: 03-18-2010, 04:51 AM
  4. Exchange Rate
    By matt.bowser in forum Excel General
    Replies: 2
    Last Post: 06-29-2006, 06:40 PM
  5. [SOLVED] how to calculate exchange rate?
    By papa404 in forum Excel General
    Replies: 2
    Last Post: 08-02-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1