gbp

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

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

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

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

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

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

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

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

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

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 *...

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

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

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

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

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