Need help with the formula for the Return the Distributor Name if they sell online or selll

Fantastic news! We've Found the answer you've been seeking!

Question:

Need help with the formula for the Return the Distributor Name if they sell online or selll over$1,000 of product, otherwise leave it blank.


	Return the Distributor Name if they sell online or sell over $1,000 of product, otherwise leave it blank

	Sales Channel	Distributor	Industry	Revenue	Country	Analysis
	Retail	The Distribution Group	Consumer Stapes	$ 1,000.00	Indonesia	online
	Online	Distributors R Us	Commodities	$ 2,500.00	Canada	online
	Online	Discount Distribution	Leisure	$ 750.00	France	online
	Direct	Freight Away	Industrial Materials	$ 1,152.00	China	online
	Retail	Infinity Trucking	Consumer Stapes	$ 345.00	Australia	online

If a distributor meets the Revenue and Quantity targets, return their name. If they only meet one of the requirements, return their industry; Otherwise, return the word "Neither."

Target Revenue	$1,000.00

Target Quantity	5

Sales Channel	Distributor	Industry	Revenue	QTY	Country	Analysis
Retail	The Distribution Group	Consumer Stapes	$ 1,000.00	10.00	Indonesia
Online	Distributors R Us	Commodities	$ 2,500.00	4.00	Canada
Online	Discount Distribution	Leisure	$ 750.00	7.00	France
Direct	Freight Away	Industrial Materials	$ 1,152.00	8.00	China
Retail	Infinity Trucking	Consumer Stapes	$ 345.00	3.00	Australia

Related Book For answer-question

answer-question

Payroll Accounting 2016

Payroll Accounting 2016

ISBN: 978-1337072649

26th edition

Authors: Bernard J. Bieg, Judith Toland

See More Books

Posted Date: Feb 21, 2024 02:32 AM

See More Questions

Long, PA, has been engaged to examine and report on the financial statements of Maylou Corporation. During the review phase of the study of Maylous system of internal control over purchases, Long was...
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
(a) Explain how a limit worth may be tended to at run-time, both in a syntaxtree middle person and in collected code. What is the importance word "settled" already? [3 marks] (b) Give a model program...
In this photo, Ramu is eating raw meat. What do Ramus behaviors suggest about how we develop self-concepts? Would you define Ramu as a human or a wolf?
Benke Ltd. buys 1,000 computer game CDs from a distributor who is discontinuing those games. The purchase price for the lot is ¥8,000. Benke will group the CDs into three price categories for...
Construct a market-value balance sheet for FedEx, using the information in Table 7.1 and stock prices reported in Sections 7.1 and 7.2. Assume that market and book values are equal for current...
Briefly describe design classes: utility, control, and boundary. How do they differ from entity classes?
Howell made long-distance telephone calls through the telephone companys computer-controlled switching system to solicit funding for a nonexistent business enterprise. What crimes did Howell commit?...
Grove Company has budgeted the following credit sales for the last six months of the current year. GROVE COMPANY BUDGETED CREDIT SALES FOR LAST SIX MONTHS OF CURRENT YEAR July $ 3 0 0 , 0 0 0 October...
Data for Minnie Hooper Company are presented in P13-9B. Further analysis reveals that accounts payable pertain to merchandise creditors. Instructions Prepare a statement of cash flows for Minnie...
A PM DC electric motor will be selected for an arm mechanism which has a length of 0.3 meters. This arm is aimed to lift 2 kg of load attached to its free end while rotating with 60 rpm at maximum...
In a process used for electroplating copper, a current of 10.23 A was passed through an electrolytic cell for exactly 1 hour. How many moles of electrons passed through the cell? What mass of copper...
A fashion is required to be coated with a thin 5 micrometer layer of silver. The coin is 5 cm in diameter and 2 mm thick. There is a silver nitrate solution at a concentration of 1 M, a source that...
The electrolysis process is carried out for a 5 M sodium chloride solution for the production of sodium hydroxide and chlorine. The process is carried out at room temperature at sea level (T=25C and...
Can a cost be both a direct cost and an indirect cost?
on January 1 , 2 0 2 3 , PharaohCorporation issued $ 7 8 2 , 0 0 0 of 7 % bonds that are due in 1 1 years. The bonds were issued for $ 8 4 4 , 3 1 3 and pay interest each July 1 and January 1 . The...
Write an essay about supply chain management in Toyota. Identify its 1st and 2nd tier suppliers and explain the supplier relations. Discuss the causes for the delays in the delivery of cars in 2021...
D Which of the following is considered part of the Controlling activity of managerial accounting? O Choosing to purchase raw materials from one supplier versus another O Choosing the allocation base...
Ken Gorman is a maitre d' at Carmel Dinner Club. On February 5, his gross pay was $800 (three days working, one paid vacation day, and one paid sick day). He also reported to his employer tips of...
The total payroll tax expense incurred by the employer on the total earnings of Joseph T. ONeill during the fourth quarter was .................$..............................................
How often must an employer file Form 941?
Show that the PSD function of a WSS random process \(\{X\}\) satisfies the following properties: (a) \(\Gamma_{X}(0)=\sum_{v=-\infty}^{\infty} R_{X}(v)\). (b) It is an even function; that is:...
Prove that \[\begin{equation*}\mathcal{F}^{-1}\left\{\sum_{k=-\infty}^{\infty} \delta\left(\omega-\frac{2 \pi}{N} k ight) ight\}=\frac{N}{2 \pi} \sum_{p=-\infty}^{\infty} \delta(n-N p) \tag{2.262}...
Repeat Exercise 3.9 for the case of two complex antisymmetric sequences. Exercise 3.9 Show how to compute the DFT of two even complex length- \(N\) sequences performing only one length \(N\)...