+ Reply to Thread
Results 1 to 8 of 8

How to sum value with different currencies & convert these resuls into one currency only?

Hybrid View

  1. #1
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: How to sum value with different currencies & convert these resuls into one currency on

    if you edit the formula, make sure that while in edit mode, you press CTRL-SHIFT-ENTER in order for it to work (there are arrays, {})
    Click on the star if you think I helped you

  2. #2
    Registered User
    Join Date
    06-12-2014
    Posts
    4

    Re: How to sum value with different currencies & convert these resuls into one currency on

    It's so great. Thanks so much for your help!!

+ 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 Formatting for multiple currencies
    By rohithkotagiri in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-04-2018, 03:17 PM
  2. [SOLVED] How to MATCH currencies then perform calculation based on currency?
    By consulttk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-12-2012, 03:17 PM
  3. Currency converter-multiple currencies
    By tsioumiou in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-29-2010, 01:08 PM
  4. Convert text value to currency value
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2008, 11:31 AM
  5. [SOLVED] Convert currency to $X.XMM
    By StephanieH in forum Excel General
    Replies: 3
    Last Post: 06-13-2005, 05:05 PM

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