currency

What I need to do is have a specific column show as a percentage if it will be 100% or less, or change into currency if higher than that. I'm not sure if it is possible, however, it's worth a try!

I've created a dropdown menu with three separate currencies. I am trying to have other cells in different tabs updated with whichever currency I've selected. Can someone help with a formula I may need for this. Thank you

Evening, Im not sure what i need to supply at present so i will let you ask me. I have a spreadsheet which upon a button press opens a user form. I enter a part number into a text box and then all the other text boxes are filled with info from a worksheet within the same workbook. In one text...

Hi On Sheet 1, I have rows of data as follows: Column A: Name of client Column B: Amount (value) in original currency Column C: Currency Column D: Transaction Date Column E: Settlement Date The Name of the client may appear on multiple rows and may have different currencies. On Sheet 2, I have...

I am pretty solid in my excel skills but am still learning about VBA. I am trying to figure out the script for performing an automated currency calulation (currency converter) when the cell in the first column is selected and a value is entered. The adjacent cell next to it should perform the...

Hello, please I need help with one problem. I have currency list for a period and specific dates I need to get the currency for. E.g. A B 24.07.2017 7,4098 kn 21.07.2017 7,4110 kn 20.07.2017 7,4103 kn 19.07.2017 7,4143 kn 13.07.2017 7,4138 kn 11.07.2017 7,4111 kn...

Hi All, I tried using If and Eval function in MS Access while im getting the data in access however it is throwing a Syntax error. My requirement is if the currency code is equal to GBP,USD,EUR,HKD the reporting currency column should have respective currency codes. If other than...

Hi, I was wondering if there exists any pre-defined function in Excel VBA that can take in 3 letter currency abbreviation string e.g. USD, EUR, AUD etc and apply the correct currency format to the cell in question. I should be able to change the input to any of the existing currency...

Hello, I have a worksheet where I have several currency options, and all the values are converted based on the currency selected. I have also added the a macro to format the cells using the symbol for the currency selected. The code I am using is below: Currency_Symbol =...

I do a daily process that requires me to take foreign currency values and convert them into US dollars (USD). For example A1 has the amount of .38 and B1 would have CAD (Canadian Dollar). I then would go to the website XE.com for the conversion rate, search for CAD converted into USD. Take that...

Hi, Is there any way we can directly pull the latest currencies from a website every time we select a certain currency from a drop down list? Eg. I want to convert a list of rates from USD to NOK. So I have a drop down cell, A2 - "USD" and "Convert to" drop down list in cell B2 - "NOK" and...

Looking online, I found the command below to turn negative currency red with a negative sign, but it didn't work for me. The result I got is red currency with no negative sign. $#,##0.00;[Red]-$#,##0.00 Can anyone help me please? TIA!

Hello, Im trying to figure out a formula but I'm struggling to even describe it to search for it online. Below I have in Table 1 a list of countries, an invoice amount, and the currency the invoice was in. In table 2 I have the countries, their native currency and the tax amount. So i want...

Hi guys I'm struggling to make my named ranges dynamic :/ I have two lists in name manager: currency =Conversion!$B$63:$B$70 and: mycurr =Conversion!$B$63:$D$70 However I need those list to be dynamic without putting them in a table. I tried this for currency...

Hello, I'm building an electricity/utilities monitoring scorecard for a Chinese factory. We want to take a daily electricity meter reading, run formulas to determine the amount of Chinese Renminbi due on the bill, and convert the Renminbi to USD. This scorecard will keep a running tally with...

Is it possible to change the currencies shown as options in this drop down list? I am constantly using two or three currencies and would like to be able to add the other two that aren't USD to that list?

Hi All, I've been struggling with this for a while and it would be amazing if I could solve it! Word of warning, My VBA knowledge is limited :(. My Goal: To have a cell where you enter (or select from a dropdown) a currency (USD,EUR,GBP etc.) that then changes all currency cells in a workbook...

Is there any way for the display formatting to be changed automatically dependent on whether ISO code I write? <tbody> ALL Lek AFN ؋ ARS $ AWG ƒ AUD $ AZN ₼ BSD $ BBD $ BYR p. BZD BZ$ BMD $ BOB $b BAM KM BWP P BGN лв BRL R$ BND $ KHR ៛ CAD $ KYD $ CLP $...

Hi, I searched a lot for this but I couldn't find a solution for this. I wonder if you could help.. To explain my problem, I have created this example. Please see the table below. I am given Travel cost, Logistic cost and Accommodation cost in GBP (£1200, £1000, £1000 respectively) These...