Question: How would I enter this into the IF formula box in Excel? Create an IF function in the Discount column to calculate the discount on

How would I enter this into the IF formula box in Excel?

Create an IF function in the Discount column to calculate the discount on the criteria below.

  1. 8% Discount on the Total Sale amount where the Item Class was Tea, a 5% Discount on the Total Sale amount where the Item Class was Coffee. Otherwise, no discount.
How would I enter this into the IF formula box in Excel?

The Greasy Bean Coffee Company The Greasy Bean Coffee Company

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

Q:

How would I enter this into the IF formula box in Excel? Create an IF function in the Discount column to calculate the discount on the criteria below. 50% Discount on the Item Price for any Quantity...

Q:

Background: You are working part-time for Lolita Bookstore. The owner, Elizabeth, asks you to create a worksheet for the business since she is aware that you know Excel. Elizabeth wants you to enter...

Q:

-60 " Use in Formula "Trace Dependents Error Checking Watch Calculation Name Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Be Ca V Fx Remove Arrows & Evaluate Formula...

Q:

help me Excel_Comprehensive_Capstonel_Wint ect Description: s project, you will apply skills you practiced from the objectives in Excel Chapters 4 through 10. You will develop a book for Frank Osei,...

Q:

Project Description: You work for a dothing distributor that has locations in lowa, Minnesota, and Wisconsin. You will use date and logical functions to complete the main ernployee data set, use...

Q:

Sam Project for Advanced functions and conditional formatting Excel 2013 I am having trouble with questions 14-19. Assignment do tomorrow Computer Software 178 New Perspectives Excel 2013 Tutorial 8:...

Q:

Please help how do it do it ? Independent Project 2-5 These instructions are compatible with both Microsoft Windows and Mac operating systems. San Diego Sailing keeps data about its fleet of rental...

Q:

I have attached pictures of the project instructions in excel. Please help. Thank you so much DETAILED ASSIGNMENT REQUIREMENTS The the Chart of Accounts, below, shows the balances in GBI accounts as...

Q:

The attached file contains explanations on how to complete the excel assignment. You MUST follow all rules and formulas to get the solutions...etc/ Please send me the completed excel sheet that...

Q:

Need an Excel expert. Having some trouble with this one. Instructions and template are attached. A Skills Approach: Excel 2013 Chapter 6: Exploring Advanced Functions skill review 6.2 In this...

Q:

When computing depreciation using the units-of-production method: Options: A) a variable amount of depreciation is assigned to each unit of output. B) a fixed amount of depreciation is assigned to...

Q:

A cavnot engine whose hgh- - temporatuwe has reservoir is at 356F efficiency of 25.0%. By an how muchh shoud dhe tempernture vesenair be of the lawe tempeatne changed to low increase the to 35.01.7

Q:

Most workers paid on an hourly basis are covered by requirements set down by the Fair Labor Standards Act and are called Blank _ _ _ _ _ _ employees. Multiple choice question. nonexempt commissioned...

Q:

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Q:

c. What were you expected to do when you grew up?

Q:

f. What was your neighborhood like? Discuss your answers with classmates. Analyze how your own cultural position is unique and how it is similar to that of others.

Q:

5. What are the advantages of a dialectical approach to intercultural communication?