currency conversion

Hi, I am new in excel formula and I needed help from the experts. I was asked to convert the currency in the column G,H,I,J,K into MYR in column L. The purpose is easier to compare the pricing. However, I was unable to do it with [=IF(G<>"",$G$2, IF(H<>"",$H$2, IF(I<>"",$I$2, IF(J<>"",$J$2...

At work I have to update the attached spreadsheet daily, filling in the day's rate for GBP -> EUR and GBP -> USD and the vice versa values (update via a formula) Is there some easy way to automate this and also backdate over the past few weeks? I have been on furlough from work because of the...

I need to write a macro for converting text to number. I have tried recording when I do text to columns but when I tried to run the macro under the same conditions as when it was recorded then it doesn't wok and the numbers stay as text. What do I need to do to make the text convert to a number?

I have a workbook where I'd like to change the currencies between USD & Euro (and back again) easily. I have a code (below) to change the format, from $ to € however, it doesn't change the value. Changing $100 to €100 is wrong as the initial value should take into account an exchange rate. So...

okay i just started using VBA/macros today and im pretty pleased with my progress so far :) but hit a brick wall i think above my pay grade... not looking for a bailout i'd like to understand this for the future. My job could really use these.... Data tab called "Quotation Tool": <tbody>...

Hello, I need to pull various exchange rates that are located in a separate worksheet (FX Table), and which must correspond to a) a certain date and b) a certain currency. The formula below seem to only account for the date, and omits the currency ticker. D18 is the date G3 is the currency Row...

I have a table containing sales, which has 4 columns; date, item name, currency, price. We sell in multiple currencies and the price in this table is the currency of the sale. So, in this table we have EUR, GBP, USD, SKK, NOK, DKK, etc. I would like to create a fifth column in my sales table...

Hopefully someone can help (I am relatively new to Excel) I need the sums of my columns to be formatted into currency, the problem is, after clicking the format into currency button, all the sums change into #######. Am I doing something wrong ? This is the formula I used =SUM(H3:H352).

I have a list of different products and their prices, which are in multiple currencies. I want to create a pivot table that will show these products with the prices all converted to a chosen reporting currency based on the conversion table. I've pasted a mock-up below, can anyone help with how...

Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Wondering if you can help. I have a workbook with 6 different worksheets each containing a report in Excel 2007. All values in the worksheets are in $USD.<o:p></o:p> <o:p></o:p> I would...