Question: create a formula in cell D4 that will determine the discount applicable to each person based on the Ticket Discounts table (F2:G9). You should be

create a formula in cell D4 that will determine the discount applicable to each person based on the Ticket Discounts table (F2:G9). You should be able to drag your formula from D4 to D8 and have it fill in all values appropriately.

This is what I came up with so far: =MIN(ABS(C4-$F4),ABS(C4-$F5),ABS(C4-$F6),ABS(C4-$F7),ABS(C4-$F8),ABS(C4-$F9)

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 Databases Questions!

Question 3 (4 points) In the above spreadsheet, create a formula in cell D4 that will determine the discount applicable to each person based on the Ticket Discounts table (F2:G9) You should be able...

this is for my intro accounting course, your excel help is greatly appreciated :) Question 1 (6 points) A B C D Possible Outcome Range Average Pass 50% or more Rewrite Less than 60% but greater than...

please help with the excel formulas and answers for the blue highlighted columns. instrustions attached Cost of Ingredients for Menu Options O Menu bibe Avec Medium Avenes Price La Y Y Cather Mains...

Please solve this Excel spreadsheet using the directions! Thank you so much! Directions: Excel Spreadsheet: The manager of Paco's Dog Treats, Inc. imported inventory data. This data must be cleansed....

DIRECTIONS Your task is to complete the Requests worksheet to provide fare information. All formulas must work when copied down the column to determine the requested information for each travel...

I need some help with starting my Excel homework Start Excel. Download and open the file named Excel_Ch05_PS1_ResourceCenter.xlsx. Grader has automatically added your last name to the beginning of...

The Red Bluff Golf Course & Pro Shop generates revenue through its golfers, golfer services, and pro shop sales. Aleeta Herriott, the pro shop manager, receives revenue data on a weekly basis. She...

I need some help with my excel homework and it's a lot to take in Registration fees, located in the EventDetails table, are based on a particular Event's EventID. Registration fees must be paid for...

U.S. Copyright Law (title 17 of U.S. code) governs the reproduction and redistribution of copyrighted material. Downloading this document for the purpose of redistribution is prohibited. Chapter 15...

Equivalent Units of Materials Cost The Rolling Department of Oak Ridge Steel Company had 2,900 tons in beginning work in process inventory (30% complete) on July 1. During July, 47,900 tons were...

An article published in the American Educational Research Journal (Fall 1998) used multiple regression to model the students perceptions of their ability in science classes. The sample consisted of...

Analyze the cost and impact of monopoly power on consumers and the overall economy.

You want to have $2.5 million in real dollars in an account when you retire in 50 years. The nominal return on your investment is 11 percent and the inflation rate is 3.5 percent. What real amount...

f. Did they change their names? For what reasons?

2. How do these communication technologies change intercultural communication interaction?

1. How do electronic means of communication (e-mail, the Internet, fax, and so on) differ from face-to-face interactions?