usd

Dear Excel friend, I need your help in finding the last value updated along with the cell formatting. I have a table with some country listing in A column and currency amount in the next column The amount columns are formatted on currency as per the country code...

Hi All, Hope you are well. I would like some help on an IF statement please. In column D, I have the following values...EUR, GBP and USD. I need a formula which calculates based on the contents of the cell in column D. My formulas for the calcs are. EUR - =SUM('Raw Data'!E2/Menu!$J$4)/'Raw...

So I have a massive text file I receive each month that I need to make edits to and then load to a database. I would love to be able to convert this text file into excel and make my edits there (save hours of time) and then convert it back to a text file. I can open the text file fine with...

Hello - I am not sure how I can add the below if statement into what I already have below. Any ideas? =IF(AND(H9="USD",E9="USD"),"No FX Trade Needed",IF(OR(H9="",E9=""),"",IF(H9=E9,"BUY","SELL")))) What I want to add is IF cell A1 and B1 start with "US" then cell H1 needs to be USD, "flag...

I want to convert file from text to column but only issue is some rows are not aligned as others. I have attached text file and sample excel file that it should look like after conversion. Text file - IEEE Credit Memo...

Hi guys! I've been recently getting into coding VBA, and am still relatively new to it (about 2 weeks in). I'm currently trying to use the following formula in vba as an array formula, but I get an error message " Unable to set the FormulaArray property of the range class". I've tried breaking...

Hi All, From an earlier post, AlanK was able to assist in coming up the formula, which works great. {=IFERROR(INDEX($A$13:$A$29, MATCH(0, COUNTIF($A$2:A2, $A$13:$A$29), 0)),"")} However, If i would Change the A2 to A1, it would give me Errors, since the extract of this is the succession of...

Hello everyone, I am stuck with tranferring the spreadsheet i receive to a new workbook by having a better overview of each invoice. I would like to have the data from table 1 Transfer to table 2 with certain lookup Aggregate formula? same invoice number, Company, Serial number, tax rate and...

Hi there, Recently I have received a payment workbook containing 2 Sheets (USD & EUR) and I would like to Transfer to a new workbook named purchase summary: Here is a selection of USD payment: <tbody> <tbody> Course type Month Description Invoice No. Lecturer Book Description Gross amount...

Hi guys, I'm a relatively basic excel user, and now I'm faced with an issue that I'm sure it's fairly simple to resolve, I just can't figure it out. I have this spreadsheet where I'm given just the name of the passengers, how many days they'll stay and which kind of room they'll use. Also, I'm...

Hi All, Please help me urgently to solve the issue I am facing. I have attached a sample data below. I want to have all values of Product 1, Product 2 and Product 3 in column deleting rows or may be in another sheet. The "Employee Number" are unque number in this case. Another condition is...

Hi, This is my first post and I hope I can get some help. I know the very basic of macros. I work on testing macros at home using excel 2003 vba, but at work I use a excel 2016. R3C2 is for a chk# or name/R3C1 is for 2 or 3 digit empl. #/R3c5 is information for adjusting transaction/r3c6 -...

Hi, I have the following situation. I am trying to look up months and currency conversion rates. I have a table which I am maintaining that looks like this. <tbody> 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 etc GBP 1.2 1.3 1.4 1.5 1.6 EUR 1.2 1.25 1.26 1.27 1.28 USD 1 1 1 1 1...

Is it possible to do multiple If Statements for the following: I need a Formula for F3 based on the information from F1 and F2 Example: F1= Business A F2= 5 THEN F3= 1500 F1= Business B F2= 10 THEN F3= 1800 F1= Business C F2= 2 THEN F3= 180 <tbody> A B C D E F 1 Business A Product...

I feel like the answer is NO but I thought I should ask: If A1= list of currencies (USD, AUD, CAD, EUR, GBP) Can A2= a number with the correct currency symbol from A1 Example: A1= USD A2= $300 A1= AUD A2= AUD 600 A1=CAD A2= CAD 100 A1= EUR A2= €500 A1= GBP A2= £240

I need a formula for J8 based on the information from J1:J7 that would be based on the information from A1:F7 J1= dropdown menu of currency J2= Manual number someone inputs J3:J7= dropdown menu of Y or N If J3= Yes, than J3=J2 (example, if J2= 3 and J3= Y than the total would be 6 because...

Hi, I have multiple rows where my cells look something like this: "+USD 17,286.24" or "-USD 40,918.66" . I just want to extract the number and I'm using this formula: =RIGHT(F9,(FIND(" ",F9,1)-1)) which works on every other cell I have except where the format reads like my examples above. Any...

I am using a drop down on cell C3 on sheet 1 with reference to C 2 to C 50 in sheet 2. In D3 sheet 1, I would like to reference whatever is in D 2 to D 50 in sheet 2, depending on which item I choose in the drop down on C3. Example: Sheet 2: <tbody> </tbody> <tbody> C D E F 2...

I have data as below Currency Location CAD 00002 CAD 00004 CAD 00005 CAD 00002 USD 00001 USD 00002 CAD 00006 CAD 00004 CAD 00005 USD 00001 I want to filter for CAD, then select the Location...

Hello All, Please can you assist me on the below issue I get frequently. I have an excel report which comes from a system. The data shows both Local Currency information and USD Currency information, across multiple tabs. In a separate excel workbook I copy and paste values all the Local...