Question: In the Enrollment sheet, in F2, create an IF statement that will 10calculate the commission rate. If the Clothes Purchase amount is zeroand the student

In the Enrollment sheet, in F2, create an IF statement that will 10calculate the commission rate. If the Clothes Purchase amount is zeroand the student is male, the commission rate is 4%. If the Clothes Purchase amount is greater than zero, or the student is female, the commission rate is 3%. Hint: Just put the commission rate, you don't have to calculate the commission. Do not use a nested IF or an IFS - you don't need either of them because there are only 2 outcomes. You will need Boolean Logi

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

15. A reheat-regenerative engine receives steam at 207 bar and 593C, expanding it to 38.6 bar, 343C. At this point, the steam passes through a reheater and reenters the turbine at 34.5 bar, 593C,...

In the Enrollment sheet, in cell E2, enter a lookup function that will look up the fee from the Eeelookup Table based on the Class in cell B2. Fill down. Hint The Eeel.okunTable can be found on the...

Please use excel In the Class Report worksheet, B24:H28 is a horizontal table you will use to look up the fees. Name the table FeeLookupTable. In the Enrollment sheet, in E2, use one of the lookup...

9 5 In the Enrollment sheet, in cell E2, enter a lookup function that will look up the fee from the FeeLookup Table based on the Class in cell B2. Fill down. Hint: The FeeLookup Table can be found on...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

its just a case study i need to write what rec for the gates family and what are financial areas of concern CASE 9 TREVOR AND LINDA GATES CASE Today is January 1, 2017 INTRODUCTORY DATA Trevor and...

this is a case study and need to state how is the gates current financial state, future, what are some reccomended changes, and what are they doing correct CASE 9 TREVOR AND LINDA GATES CASE Today is...

PROBLEM 7: Education & Profitability Review FY 2012 results for ITT Educational Services. Calculate break-even point based on number of student enrollments based on 2012 results. Show all of the...

I really need help with making the balance sheet and income statement and post closing trial balance. Graded Project Ice Cream Systems 1 PROJECT INFORMATION 1 PROJECT INSTRUCTIONS 14 SUBMITTING YOUR...

If 32P-labeled ATP provides for the reactions of glycolysis, which of the following would be TRUE about 1.3 biphosphoglycerates? A. 50% of 1,3-bis phosphoglycerate would contain 32P B. 100% of...

Discuss the importance of feedback in the strategic-management model.

On July I. 2 0 0 8 , your new employer Ford Motor Company deposits $ 5 0 0 0 into your money market amount, as part of your employment bonus. The account pays interest at 5 % per year. You expect to...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...