gbp

  1. D

    I am trying to match the exchanged rate based on the date of the sales data and convert the currency to GBP, Then make a pivot table to show sales fro

    Attached is a set of sales data. The task is to produce a graph showing the total paid orders in GBP, with the months across the horizontal axis and sales volume (including postage) on the vertical axis. The graph should aim to compare year on year performance and I need a slicer to be able to...
  2. M

    Convert EUR to GBP VBA Script

    Hi, Im trying to create a script to change all the values on the press of a button from GBP to EUR and back if the button is presed again, can anyone help. I search online and the forum but not joy. Many thanks
  3. R

    DAX measure to get rate from dislocated table

    Hi, I am struggling to return a result with a Dax formula. I have a Fact table that has some data Fact Table <tbody> Date Account Curr Trans Amt GBP Equiv USD Equiv 01/04/18 12345 EUR 10,000 9,000 14,000 01/05/18 12445 USD 15,000 10,000 15,000 01/10/18 12445 GBP 1,000 1,000 1,425...
  4. C

    A simple currency conversion one I hope!

    Hi everyone, Hopefully a simple one for someone but I cannot get it to work! I’m trying to convert all currencies on a spreadsheet to USD Column B has the base price, Column C has either (GBP,USD,EUR). What I am wishing to do is in column D show a USD price only , so if column C says GBP or...
  5. K

    Totaling of different currencies in a column separately

    Dear Experts, I have a range of currencies in a single column, I want to have totals currency wise separately. the example values are given below. I want the 3 currencies totals separately in another column. <colgroup><col></colgroup><tbody> GBP 428.00 GBP 264.11 GBP...
  6. B

    Macro to add additional rows for orders paid in Multiple currencies

    I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...
  7. B

    Macro to add additional rows for orders paid in Multiple currencies

    I need to develop a macro that is currently beyond me. Here is the scenario. The company will sometimes book an order that will be paid in different currencies (e.g. USD, GBP, EUR, JPY, AUD, etc). We add a commission rate for each currency we're going to pay the rep on. On a line we might have...
  8. D

    IF Statement combined with vlookup and formula

    Hello, This should be straightforward but ive drawn a blank. We are given; Sheet1: Col B: range of currencies in this format. A sample list has been provided but there may be more so the formula has to be dynamic enough to allow for this. Col C: Value is given but could be any given value...
  9. E

    VBA / Macro - Sort by ROW - Specific Requirement

    Dear Community, I have a daily report which is currently manually sorted. I would like to do this automated with a macro if possible. The "Row Headers" look something like this: <tbody> 302(USD) 304(EUR) 305(USD) 307(USD) 308(USD) 310(GBP) 311(USD) 342(EUR) 368(EUR) .... </tbody>...
  10. L

    vlookup with multiple criteria

    Hi All, I need some assistance please. i'm using excel 2016. Col W contains a revenue amount Col U contains the currency used Col X i need to contain the result of converting the rev amount in col w & col U so for instance if col W is 50,000 col U is GBP col X should be 46,000 ( 50,000 *...
  11. M

    Return the last updated value with the cell formatting

    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...
  12. S

    IF formula for 3 calculations based on the contents of Column D

    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...
  13. F

    If/Then and look up in same formula...must be an easier way

    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...
  14. K

    Automatically Change to Correct Currency

    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
  15. R

    Sumif formula with dynamic range

    Hello everyone, I am trying to create a common sumif formula for different ranges in different excel files. I extract complete list for all customers and then create a separate workbook for each of these customers. Hence these files relate to different customers, with whom I may be dealing in...
  16. S

    Formula Help

    Hi any help on the below problem would be appreciated, alternatively if it's been answered elsewhere please direct me..... <tbody> Month Revenue LC Revenue GBP Invoice LC Invoice GBP FX Rate 1 2,000 1,333.33 1.5 2 0 0 1.75 3 300 150 2 4 2,100 ???? 0 0 1.25 5 300 ???? 0 0 1.75...

Some videos you may like

This Week's Hot Topics

Top