Currency Conversion: Convert In GBP
Apr 10, 2009
i have an order book which lists the value of each order against the currency it was ordered in. So in column A i have a list of currencies (THB, GBP, AUD, USD, the user clicks the appropriate one) and in column B i have the figure (23.50). I want a formula that can convert all these in GBP so that i can report the order totals in one currency in column C. =(IF A1="THB", B1/50, "") can i adapt this to include all variables? I will add a table with the currency conversion rates.
View 2 Replies
ADVERTISEMENT
Jun 23, 2008
I am working on a sheet that logs sales enquiries and quotations. The quotations may be made in either Dollars, Euros or Pounds. However, I want the 'reporting' column to be Pounds. I would appreciate any advice on the simplest way of achieving this.
Imagine column A is dollars, column B is Euros and column C is pounds. Most of the time the quotations are done in pounds and the other two columns will be blank. Also, there will only ever be one figure quoted per row. Would it be easier to create a fourth column (D) to consolidate the three separate figures together? We are using fixed exchange rates for the year, so to convert to pounds we will multiply any dollar quotations by 0.5 and any euro quotations will be multiplied by 0.69.
View 9 Replies
View Related
Aug 16, 2006
I'm using excel 2000
Is there anyway to format cells such that I can enter values as Euros and they automatically convert to £
eg If I enter 14.60 (Euros) it automatically displays as £10.00, my conversion rate of 1.46 is constant throughout
I know I can do the copy paste special divide thing but the above would be a much nicer solution
View 9 Replies
View Related
Jun 12, 2008
I have a sheet of prices in USD, and want to be able to convert those numbers to Euro. I realize there is no formula to do this...
I was going to list USD prices in cell A (which I was going to hide), and then in B have a formula to multiple the contents of cell A with the exchange rate.
Is there a way I can create a dropdown cell and based on the contents of the dropdown change the currency items in cell B?
View 3 Replies
View Related
Feb 15, 2013
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, 12/31/2011)". All currencies will be against USD.
The trick is that it will have to be created as Add-On so that it can be used in any Excel spreadsheets. The second trick is that I cannot have VBA to make any internal connections to other workbooks or applications.
So the only thing that I can come up with would be to write a VBA code that would include all values and currency rates in it. The structure that I have in mind would be something like:
Code:
Function Fx(Vl As String, Dte As Date)
Dim Rte As String
If Vl = "EUR" And Dte = "12/31/2011" Then
Rte = 0.7723
ElseIf Vl = "EUR" And Dte = "12/31/2010" Then
Rte = 0.7546
[code]....
The above code does not work!There will be at least twenty different currencies and at least 15 periods.
View 2 Replies
View Related
Apr 1, 2009
The FOB PRICE in sheet JAN09SEA is in any of three currencies, HKD EUR or USD.
The output on sheet CONSOLIDATE should only be USD.
Also, you can see that some countries send their freight in two or even three different currencies. This would need to be accounted for.
Additionally to the currency issue, I need to sort the output to RM or FG. For that, on sheet CONSOLIDATE, we have a button located in G1 to switch types.
E.G. if presses for FG, the formula should only check for the values where the row is marked with FG in column X.
The freight charge is always in HKD and needs to be converted to USD as well. Also it should be FREIGHT = FREIGHT CHARGE + SURCHARGE converted to USD.
This is quite a lot of information. I hope someone can think of a solution for the problems.
If you need more information.
View 9 Replies
View Related
Jan 16, 2009
how can i convert the currency with macro from EUR to Slovak Crowns.
I have this, but this works only for one cell, but mostly i need to convert range of cells.
View 6 Replies
View Related
Nov 24, 2006
I have a Userform where i have the user in put a dollar amount in a text box. Im having difficulty getting this assigned to a variable as an integer. I get a "type mismatch" error. I have tried declaring the variable as an integer, and tried the cint() function, but i get the same error.
View 3 Replies
View Related
Feb 13, 2007
I would like to create a formula that would break a number into seperate currencies as follows:
Any amount that is >0 would be flagged as "gp"
Any amount that is .1 would be flagged as "sp"
Any amount that is
View 9 Replies
View Related
Nov 30, 2007
I am looking to write a small macro to convert all figures on a page to either EUR or $ at the click of a button
View 5 Replies
View Related
Mar 11, 2012
How to make EXCEL 2007 Automatically convert all my CURRENCY symbols in all cells formatted for CURRENCY in THE SAME SHEET to the one and ONLY currency selected in JUST ONE cell ? (i mean, after conversion, all of them are Not just display currency symbols, but Calculable monetary values like regular Excel's built-in currency format)
I am a dummy in VBA so I really am not familiar at all if the solution is really one of VBA. I don't even know how to start programming VBA at all in Excel.
View 3 Replies
View Related
Apr 23, 2009
I have several rows which lists different currencies - USD, GBP, EURO, JPY etc.,
A1 usd 5000
A2 GBP 7000
A3 USD 3400
A4 EUR 12000
A5 JPY 89000
A6 EUR 1000
At the bottom I want to show the total of each currency separtely.
View 13 Replies
View Related
Oct 10, 2009
When I am converting a time from Hours/Minutes to Hours/Tenths, Excel is not converting it consitantely. EXAMPLE: 1:15 = 1.25. When I format the cell to present only one place past the decimal point, sometimes the cell will round up to 1.3, and other times it will round down to 1.2. What am I missing?
View 3 Replies
View Related
Jul 30, 2009
I have just been told that one of our servers is being replaced this weekend. I have thousands of hyperlinks in excel docs that reference this server. Other than manually reestablishing the links one by one to the new server, is there a way to do some kind of global change to replace the old server name with the new server name?
These are not hyperlink formulas, but rather Insert>>Hyperlink.
Or, is there a way to convert these hyperlinks to hyperlink formulas that would omit reference to the server and thus not be broken during the conversion?
Grasping at straws because I cannot envision having to relink these one by one.
View 3 Replies
View Related
Feb 12, 2009
I have a worksheet with values in yen in the C column. My boss (who will not get it through her head that I am not a programmer) wants a macro that will take a yen/$ conversion rate (e.g., 88 yen/$) in cell J1 and convert all the amounts in column C into dollars with a 5% markup and rounding up. If I was doing this as a worksheet calculation rather than a macro, the calculation would look like this:
View 7 Replies
View Related
Feb 9, 2010
The following codes publish the worksheets "Estimate" & "Photos" to a PDF file, it all works great accept that the sheets remain selected in the WB after the sheets have been published. How do I unselect the estimate and photos sheets?
View 6 Replies
View Related
Nov 4, 2008
If I have a scoring grade for different categories (8 in total) & the grades looks something like that: 1a=500, 1b=400, 1c=300, 2a= 250, 2b=210...& so on till 4c, but with different numbers for each category.
I need to come up with a total score of points if a person is given a certain grade from the above. ex. if they scored 2a on a certain category, 1c on
another & with all the rest of 8 categories scored. The number i need to come up with is the total points.
View 9 Replies
View Related
Aug 26, 2009
I have two sets of data that I need which is obtained from one source.
Basically, the stats I am working with in excel are Processing Time (minutes/seconds) and Volume Per Hour. I desperately need a formula that will allow me to convert the processing time into Volume per hour.
Example: Average Handle Time, 7min 7 seconds = x per hour. If it was just 7 minutes flat I could simply divide that into 60. I also can't make it 7.7 and divide that because 7.7 doesn't equal 7m7s.
Does anyone have any thoughts on a way to do this? I found a conversion chart online that allowed me to do this work manually 'Conversion Chart: Fraction of an Hour to Minutes', but I haven't determined a way to make a formula out of this.
View 9 Replies
View Related
Sep 10, 2009
I have an spreadsheet that is monitoring the productivity of agents, as well as the time that it takes to complete each task. My workforce keeps time as .50 = 30 minutes. So 7 and half hours is actually 7.5. Agents are putting the actual time of it took such as 15 minutes however I would like to insert a formula that will convert this for me manually. I know I could give them a conversion sheet, but it took quite a while to get them to actually be able to work in excel. So I would like to add this formula.
View 9 Replies
View Related
Apr 3, 2007
I am trying to convert numbers from three cells into a date in one cell. I tried using the =DATE function, but it did not work. In A1, B1, C1, I have 1, 15, 2002. I would like cell D1 to take the info from the preceeding three cells and display "January 15, 2002"
Presently, I have A1...C1 formatted for "General." D1 is formatted for "Date." Yet I get the answer "August 23, 1907" (or 2792 as 'General').
View 3 Replies
View Related
Jun 19, 2006
shown in the attached picture.
View 8 Replies
View Related
Aug 30, 2012
How can I make my data in "input" tab to look like in the "output" tab the easiest way?
View 1 Replies
View Related
May 20, 2014
I would like to convert date written like this "April 24, 2014" in Excel Date format.
Is it possible to do it with a formula or data import?
View 6 Replies
View Related
Jul 29, 2014
why is that I have the same time value but with different conversion results?
I have values in column A10:A26 with an average time of 00:00:38 result with converted value of 7052.04.
When I type 00:00:38 in Column A30, it gives me a result of 7139.37...
Why do I have different conversion results knowing that I have the same time of 00:00:38?
I Have attached a sample workbook.
View 14 Replies
View Related
Mar 6, 2008
Why when I convert the following data, why the plus sign "+" converts to a /K?
I'm trying to convert values in groups of cells to a 3 of 9 barcode.
The value would be something:
+R4235
But when the font is changed to a 3 of 9 barcode and then I test the barcode in Notepad I notice that the plus sign is replaced with a /K.
View 5 Replies
View Related
Nov 8, 2009
I am using excel for invoice making...In the end i have a total amount. I need to type it in words for every invoice at present.
How can i convert it to words automatically? Is there any formula to it?
Or is there anything else? Please suggest me friends.
View 9 Replies
View Related
Dec 25, 2009
I am trying to create a spreadsheet that will take all my grades from the semester (I'm a college student) and compute my GPA. I managed to get a weighted average for each class, but the grade is on a scale of 1-100. I need to convert that to a letter grade, and then a 4.0 scale. How can I set it up so that it will return "A" if 90<Grade<100, "B" if 80<Grade<90, etc.? I'm apologize if this is something simple, but I've been trying to find the right function for a long time.
View 5 Replies
View Related
Jun 24, 2014
So I record a macro but it see only following bit
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Select
I want this selection to be converted to numbers but in proper way (There is a green thing in corner in every cell and on top of column a yellow field with exclamation mark. When whole column is selected and you apply appropirate convert function from this exclamation mark menu it will convert it properly.
While if you just click on excel tab and choose numbers it just does not change it to numbers
View 2 Replies
View Related
Jul 2, 2009
as i understand CInt() converts STRING variables to INTEGER variables. I am trying to create an inputbox, with input validation. So, if the user types in an integer, it will continue to a msgbox; if they type a number in string format, as in 'two', it will convert this into an integer and again display it in a msgbox; if they press nothing a msgbox will appear telling them there is no input; and if they press cancel the programme closes.
View 4 Replies
View Related
Sep 18, 2009
See here:
http://www6.uniovi.es/~antonio/uned/...-754hex32.html
This site allows me to enter a 32-bit Hexadecimal Representation and get Decimal Floating-Point result.
For instance, 4224A012 gives me 41.2.
Is there a UDF available to do this inside of Excel?
View 3 Replies
View Related
