exchange rate calculation

  1. C

    Macro to extract numbers from a text string, perform math operations and return numbers back to text string.

    I need to convert commentaries in excel on financial data from dollars to euros every month. Rather than manually calculating and converting the numbers and changing the $ sign to €, is it possible to write a macro that extracts numbers from a text string, multiply the numbers by an exchange...
    • chinleongong
    • Thread
    • currency symbol exchange rate calculation extract data from string macro numbers & text
    • Replies: 7
    • Forum: Excel Questions
  2. A

    Formula to calculate a total year to date figure multiplied by the most current exchange rate

    hi Folks Thanks for your help in solving one problem..now am trying to get a handle on another. The aim of this formula is as follows: summarise a column so that it adds up all the net_accounted but only those ones with an account status of BS (that's Balance sheet ....not anything else...

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
Back
Top