currencies

  1. K

    Totaling of different currencies in a column separately

    Dear Experts, I have a range of currencies in a single column, I want to have totals currency wise separately. the example values are given below. I want the 3 currencies totals separately in another column. <colgroup><col></colgroup><tbody> GBP 428.00 GBP 264.11 GBP...
  2. R

    SUM of different currencies in single column, SUM of filtered data with criteria.

    Hi every one, I'm preparing a database for my company's sales data. we deal in different currencies, but I want all the accounting values of one category in single column. This led to having different currencies in single column. Also I have categorized data into fiscal quarters with a formula...
  3. R

    Currency Calculator

    Hello! I want to make a currency calculator in Excel but not quite sure how to do it. Basically, I want 2 sheets. The first sheet is where I can calculate the currencies and the second sheet where the data is located. So in the first sheet, I have a drop down for types of currencies (USD, BHD...
  4. E

    Adding Columns with Various Currencies

    Hi All, I have quite a few tabs, I need to go into each one and add a "Total" column at the end. However my problem is I want to separate the currencies so if column A =EUR AND B has the corresponding value, I want to place this into a column marked "Total EUR", how is this done as there are a...
  5. M

    How to get live exchange rate data in excel using Oanda?

    Hi all, I have a number of currencies (all the currencies that are mentioned in Oanda's currency converter dropdown) in hand and I want to convert those in USD. This I need to do every day from the currency converter page of Oanda. Is there any way I can automate the task? I tried some of the...
  6. G

    help with workbook-wide cell formatting

    Good day, I have been looking for a solution existing on the forums but have come up empty handed. I am looking for VBA code (from my understanding) in order to replace all cells within worksheets of my choosing with a different format, and vice-versa. Detail: I have financials and models...
  7. I

    Noob - Create a UDF for currency conversion with VBA only - no external connections

    I am a beginner in VBA</SPAN> The main objective is to create a, UDF with 2 parameters (Currency, Date) in order to display currency exchange rate based on the currency and date. Let’s say I want to find an exchange rate between USD/ EUR, then I would have a formula something like “=FX(EUR...
  8. S

    Looking for Currency Exchange Formulas/Spreadsheets

    I have an account where the client buys and sells Euros and Dollars on a regular basis. This would be simple enough to track except I have to keep track of the original inventories exchange rate. Let's say an original purchase of 100,000 Euros is at 1.5% (to the Dollar). The client then...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top