Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

English For Accounting And Auditing Students Book

Authors: Dejan Arsenovski

1st Edition

869212253X, 978-8692122538

More Books

Students also viewed these Accounting questions

Question

describe the objectives of marketing implementation and change

Answered: 1 week ago

Question

=+ (c) Show that f is a measure on Fand agrees with a on Fo.

Answered: 1 week ago