Answered step by step
Verified Expert Solution
Question
1 Approved Answer
USD 0.72 CAD 1.10 EUR 1.00 How do I use the XLOOKUP function on excel to convert my profits to the corresponding country's currency? AutoSave
USD | 0.72 |
CAD | 1.10 |
EUR | 1.00 |
How do I use the XLOOKUP function on excel to convert my profits to the corresponding country's currency?
AutoSave OFF Home Insert X Paste 32. C. J2 1 Date 2 47 69 112 124 157 165 220 3/31/18 Enterprise France 342 12/31/17 Governmer France. 386 387 589 610 626 630 632 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 Draw Page Layout Calibri (Body) V 11 BI U V X fx A B D Product Amarilla Montana Paseo Segment Country 8/31/17 Channel Pa Canada 3/31/18 Small Busir Canada 12/31/17 Governmer Canada 6/30/18 Small Busir Canada. 10/31/17 Enterprise Canada VTT 12/31/17 Enterprise Germany Amarilla 3/31/18 Enterprise Germany Amarilla Velo Carretera Paseo 6/30/18 Enterprise France Paseo 6/30/18 Enterprise Germany Paseo 3/31/18 Enterprise United Stat Carretera 6/30/18 Enterprise United Stat Montana 12/31/17 Small Busir United Stat Paseo 2/28/18 Enterprise United Stat Paseo 3/31/18 Governmer United Stat Paseo Ready Sales Summary Filter Mode K Formulas Data Review A^ A V A v = = = == F G H I 2,761 3,803 Currency Profit 8283 CAD 950625 CAD 121 21255 CAD 948375 CAD Sale Price COGS 12.00 300.00 7.00 3,794 300.00 2,954 125.00 3,165 125.00 4,220 103.00 4,244 125.00 3,945 7.00 125.00 354480 CAD 379800 EUR 506340 EUR 509220 EUR 19725 EUR 2,988 358560 EUR 3,513 125.00 421560 EUR 3,446 125.00 413460 USD 3,627 125.00 435240 USD 3,495 300.00 873750 USD 2,992 125.00 359040 USD 4,493 7.00 22462.5 USD + Sales Data E Units Sold View Tell me Exchange Rates 24,849.-T (122,325.00) (1,928.00) (120,075.00) (9,355.00) (34,675.00) (221,957.00) (164,095.00) (398.00) (13,435.00) (76,435.00) (68,335.00) (90,115.00) (45,450.00) (13,915.00) (3,135.50) ab Wrap Text v Merge & Center v K Converted Currency L Sales (1) Accounting $ % M
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started