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
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 |
Step by Step Solution
3.36 Rating (168 Votes )
There are 3 Steps involved in it
Step: 1
Heres the formula you can use to return the Distributor Name if they sell on...
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
Payroll Accounting 2016
Authors: Bernard J. Bieg, Judith Toland
26th edition
978-1305665910, 1305665910, 1337072648, 978-1337072649
