ZuoTi.Pro
Question

Create a Nested IF function to rank the customer sales by the average sales per order....

Create a Nested IF function to rank the customer sales by the average sales per order. If the average sales amount per order is less than $20, rank as Low, $20 to less than $40 “Average,” $40 to less than $100 as “High,” and over $100 as “Prime.” Im having difficulty writing an if function for this in excel.

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

A В 6948 6949 6950 Average sales 6951 20 AVERAGE 6952 21 AVERAGE 6953 40 HIGH 6954 41 HIGH 6955 100 PRIME 6956 101 PRIME 6957

Hi Mate,

I have applied the formula in column A and tested also for its accuracy.

For cell A6951, the formula is

=IF(A6951<20,"LOW",IF(A6951<40,"AVERAGE",IF(A6951<100,"HIGH","PRIME")))

Copy and paste this formula for all Average sales and you will get the desired result.

Please hit like. In case of doubt, please comment.

0 0
Add a comment
Know the answer?
Add Answer to:
Create a Nested IF function to rank the customer sales by the average sales per order....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • I am having difficulty writing the Nested function. The formula  I used was =IF(B2<20,"LOW",IF(B2<40,"AVERAGE",IF(B2<100,"HIGH","PRIME"))). All I got...

    I am having difficulty writing the Nested function. The formula  I used was =IF(B2<20,"LOW",IF(B2<40,"AVERAGE",IF(B2<100,"HIGH","PRIME"))). All I got was Prime for everything. need help with a nested function in excel. 8. In the "Order Quality Nested" column, create a Nested IF function to rank the customer sales by the average sales per order. If the average sales amount per order is less than $20, rank as Low, $20 to less than $40 "Average," $40 to less than $100 as "High," and over...

  • I am confused on how to write the function for the following problems. Based off the...

    I am confused on how to write the function for the following problems. Based off the excel document provided.   13. In the "High Annual Sales" column create a function to identify customers that have sales greater than the total average sales of all customers for the year. If greater than the total average, the function should return "Blue Chip," otherwise return "Basic." Conditionally format the "Blue Chip" as white text with a blue fill. 14. Insert a new column to...

  • How would average customer sales and average customer profit change for a business with 10% very...

    How would average customer sales and average customer profit change for a business with 10% very satisfied customers, 35% satisfied and 55% somewhat satisfied? ( i don't understand how it affects the weighted average profit margin please explain in details) Customer Percent 25% 35% Customer Revenue (Customer Sales) 1200 800 Retenti Custom Margin Gross Profit on Cost er Profit 60% $720 $100 $620 50% $400 $100 $300 Customer Satisfaction Very Satisfied Satisfied Somewhat satisfied Somewhat dissatisfied Dissatisfied Very Dissatisfied 20%...

  • 5. Create a java application that uses nested loops to collect data and calculate the average...

    5. Create a java application that uses nested loops to collect data and calculate the average rainfall over a peniod of years First the program should ask for the number of years. The outer loop will iterate once for each year. The inner loop will iterate 12 times, once for each month. Each iteration of the inner loop will ask the user for the inches of rainfall for that month, the program should display the number of months, the total...

  • Write a three parameter generic function that will average the numbers selected from a list but...

    Write a three parameter generic function that will average the numbers selected from a list but only those between low and high, inclusive.   That is, this is a three parameter function, with list, low, and high cutoff values. Be careful, the average depends only on the selected numbers. B. Test your function with the salesRevenue list and having a low = 30 and high = 100. Your function should return the average of those numbers. Print this out, properly identified....

  • In cell B25, calculate fixed costs by use a nested IF function to display the Low...

    In cell B25, calculate fixed costs by use a nested IF function to display the Low Risk Administrative Cost if the value in cell B18 is Low, to display the High Risk Administrative Cost if the value in cell B18 is High or display the Standard Risk Administrative Cost. Format as Accounting with 0 decimal places. Bean Healthcare Beantacob - Excel Pile fx Home Insert Page Layout Formulas Data Review View Help 2 A @ @ Auto Sum Recently Financial...

  • A credit card company has found that its average balance per customer is normally distributed with...

    A credit card company has found that its average balance per customer is normally distributed with a mean of $250 and a variance of 2500.    a. Find the probability that the balance is over $300    b. Find the probability that the balance is less than $150    c. Find the value such that the probability of a customer’s balance being less than this amount is 0.05    d. Determine the values of a and b such that P(a...

  • SECTION B: SQL Data Manipulation Language 1. The following are parts of tables from customer sales...

    SECTION B: SQL Data Manipulation Language 1. The following are parts of tables from customer sales databases schema at the AWIE Sdn. Bhd. Company SALES CustID Date SaleAmount 2. Jun 2014 100.22 CUSTOMER CustID FirstName LastName DOB Phone 1 July 2014 909.95 어 1 John Smith 2/4/1968 012 222-2222 3 July 2014 522.95 2 Steven Goldfish 4/4/1974 013 455-4545 3 Dec 2014 100.00 3 Paula Brown 5/24/1978 017 323-3232 4 Smith 4 James 20/10/1980 010 323-8888 Dec 2014 555.55 a)...

  • Lab #6 Number Guessing Game – Loops and Nested Loops Requirements: Design, develop, test, and submit a program for a Number Guessing game. The program will select a random number between 0 and 100, al...

    Lab #6 Number Guessing Game – Loops and Nested Loops Requirements: Design, develop, test, and submit a program for a Number Guessing game. The program will select a random number between 0 and 100, allow the user to try up to 10 times to guess the number, and tell the user if each guess is too high, too low, or correct. The actual game portion must be a function...you can use more than one function in your program. The amount...

  • QUESTION 1 Customers arrive at a hair salon according to a Poisson process with an average of 1...

    QUESTION 1 Customers arrive at a hair salon according to a Poisson process with an average of 16 customers per hour. Which of the following is most likely true, based on this information: a. The hair salon serves customers on a walk-in basis (rather than by appointment times) b. If 10 customers arrive in the first hour, it is likely that 22 customers will arrive in the next hour. c. If the salon can serve an average of 20 customers...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT