Question: How do I find projected sales (I column) just for column B that have more than 1 child( example for children 1, 2, and 3

How do I find projected sales (I column) just for column B that have more than 1 child( example for children 1, 2, and 3 ? and leave 0 children blank

Provide steps.

Tell me Home Insert Draw Page Layout Formulas Data Review View Automate G Paste Calibri (Body) V 12 V A A ab General BIU V A J17 fx A B D E F G 1 Customer # Children Household Ir Number of V Mobile Use Region Insert % .00 .00 0 Conditional Format Formatting as Table Cell Styles Delete Format v H J SALES W/O PROMO SALES W/ PRC PROJECTED SALES FOR 10% CLOTHES K AM V Y Sort & Filter V Find & Select Comments Share Analyze Data Sensitivity M number of children Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 Grand Total 79.98082192 2 1 0 2 71 1 2 0 4 46 0 4 3 5 4 22 2 73 0 2 97 0 6855 22.95 8 38 5 31.6 6 5 0 2 72 0 1 57.9 8 69 6 1 3 68 0 8 37.5 7 0 4 82 0 4 49.7 9 8 1 3 15 0 10 9 3 4 34 1 85 43.7 11 10 1 2 18 0 8 12 11 2 1 99 1 5 13 12 3 4 60 0 1 14 13 2 3 70 1 3 66.7 15 14 3 1 92 1 4 146.9 16 15 3 2 52 1 5 70.7 Grand Total 17 16 1 2 75 0 7 60.1 18 17 0 3 41 0 5 19 18 0 4 45 0 2 89.8 20 19 3 1 24 1 8 97.2 21 20 2 3 61 1 4 123 22 21 0 1 36 0 8 20.3 50.4 23 22 2 3 100 1 00 8 146.9 24 23 1 2 18 1 7 48.5 25 24 0 3 9 1 7 26 25 1 1 54 0 2 27 26 3 2 23 0 8 22.6 30 Sales Demo number of children Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 79.98082192

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Marketing Questions!

Research on risk management processes/components Research on Qualitative and Quantitative measure of credit risk under banks when making/taking lending decisions

Adjust one of the earlier models to have constrained growth with a carrying capacity for humans and a carrying capacity for mosquitoes. Examine and discuss the effects of these changes. A logistic...

Case study Question Q1. Mr Kizio has been hired as the Director of Finance for Uganda Baati Ltd, the owners are depending on his expertise to maximize their wealth and grow profitability for their...

Instructions Form 1040 Schedule 1 Schedule 2 Schedule A Schedule B Schedule C Schedule D Form 8949 v Instructions Note: This problem is for the 2021 tax year. Devon Bishop, age 45, is single. He...

The instruction for my assignment is in my attachment. This is a tax return project. So, anyone who is an expert in tax accounting please help me. I have provided details and pointers for all of you...

Tax Return #3Schedule A John and Susie Ryan are married and file a joint return. John's social security number is 412-34-5670 and his date of birth is May 12, 1976. Susie's social security number is...

Possible Multiple Choice Questions for the Exam. Focus on the topics discussed in class. Chapter 1 Multiple Choice Identify the choice that best completes the statement or answers the question. ____...

Foot Locker, Inc.s consolidated financial statements in Appendix B at the end of this book report a number of liabilities. Show amounts in thousands. 1. The current liability section of Foot Locker,...

Describe network security vulnerabilities. Use the industry standards and best practices to identify the vulnerabilities. Describe why it is vulnerable and what the implication is if it is not...

The process of setting procedures for making decisions about an organization's long - term goals is called: Job analysis Gormetic plannt 8 Hit planning Environmental se arining Nots

Given the following information, construct the firms balance sheet: Cash and cash equivalents................$ 300,000 Accumulated depreciation on plant and equipment..800,000 Plant and...

Disney purchased a new roller coaster for $250,000 at the beginning of the year. During the year, the roller coaster's net proceeds were $50,000, and then it was sold for $190,000. Use this...

Case Study - Scenario 1 Your Store Manager has had a stressful month. It is the end of the financial year and sales revenue in the Timber and Plumbing & Electrical departments is down on targets,...

An employee has come to you with an issue involving a co-worker. In general, the sales team is a cohesive team, but now a relatively new member of the team is rubbing people the wrong way. She never...

The return of goods to the supplier will affect the purchase account. Question 27Answer True False

Dr. George E. Beeper is a single taxpayer. He lives at 45 Mountain View Dr., Apt. 321, Spokane, WA 99210. Dr. Beeper's Social Security number is 775-88-9531. Dr. Beeper works for the Pine Medical...

David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...

Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...

Give an example of a process conflict, a task conflict, and a relationship conflict in a group or organization.

The observers use Form 1 to report on the mediation, discuss it with the parties and comediators, suggesting ways to improve it.

Form groups of at least five persons, two conflicting parties, two comediators, and one or more observers. A class may have several mediations going on simultaneously in different areas of the...