+ Reply to Thread
Results 1 to 6 of 6

Convert a list of receipts in one currency using an exchange rate from a signle cell

  1. #1
    Registered User
    Join Date
    08-01-2012
    Location
    Southern England
    MS-Off Ver
    Excel 2008 Mac
    Posts
    23

    Convert a list of receipts in one currency using an exchange rate from a signle cell

    Hi
    I have receipts in UK pounds that are listed in Column F rows 6 to 25.
    I have the exchange rate to Euros in Cell C4.
    How do I simply convert all the currencies rather than doing each cell individually (F6/C4; F7/C4; F8/C4 etc)?
    Help much appreciated.
    David

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

    Hi,

    Do you mean that you just want the total of F6:F25 converted to euros? Which could be implied by your mention of not wanting each cell individually

    Or perhaps you want in F6 and then copied down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,998

    Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

    =F6/C$4
    And drag the formula down
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    08-01-2012
    Location
    Southern England
    MS-Off Ver
    Excel 2008 Mac
    Posts
    23

    Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

    Apologies for not being clear.
    What I need is each receipt converted into Euros.
    i.e. the value in F6 in shown in G6 as Euro; the value in F7 in in G7 in Euro etc.
    I don't need the total of all column F.

  5. #5
    Registered User
    Join Date
    08-01-2012
    Location
    Southern England
    MS-Off Ver
    Excel 2008 Mac
    Posts
    23

    Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

    Hi to both of you. Thank you. That's exactly what I needed.
    Your help is much appreciated by this 70 year old!

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Convert a list of receipts in one currency using an exchange rate from a signle cell

    Quote Originally Posted by Theale View Post
    Hi to both of you. Thank you. That's exactly what I needed.
    Your help is much appreciated by this 70 year old!
    Glad to have helped and thanks for the rep....I'm only two years behind you.

+ 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. Currency Converter based on pick list and exchange rate
    By rguliuzza in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-04-2012, 05:40 PM
  2. Possible to do in-cell query for currency exchange?
    By jamesv in forum Excel General
    Replies: 1
    Last Post: 05-30-2012, 07:09 PM
  3. Query for Currency Exchange in Cell - Possible?
    By jamesv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2012, 07:06 PM
  4. Historic Currency Exchange Rate Lookup
    By andy_dyer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-01-2010, 12:17 AM
  5. [SOLVED] How to get exchange rate into cell
    By Piotr in forum Excel General
    Replies: 2
    Last Post: 01-29-2005, 07:08 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