Question: 2 . 5 Use an IF function in cell to calculate the commission earned for beverages for order 1 . a . The beverage commission

2.5 Use an IF function in cell to calculate the commission earned for beverages for order 1.
a. The beverage commission is 10% of the total sale if the customer buys a beverage.
b. If the beverage sale amount (cell (D10) is greater than 0, the beverage commission equals the sales total (cell (G10) multiplied by the beverage commission rate fcel (64)
2.5 Use an IF function in cell to calculate the commission

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 General Management Questions!

Q:

2 . 3 Use an IF function in cell to calculate the commission rate for the donuts sale for order 1 . a . The commission rate is 2 % for donuts sales that total more than $ 1 0 . It is 1 % for all...

Q:

2 . 3 Use an IF function in cell to calculate the commission rate for the donuts sale for order 1 . a . The commission rate is 2 % for donuts sales that total more than $ 1 0 . It is 1 % for all...

Q:

Does my work seem correct given with these instructions? A14 x fx L A B C D E F G J K sales performance. Because the bakery makes so much money on beverages, she earns 10% commission (based on the...

Q:

to calculate the commission earned for beverages for order 1 . a . The beverage commission is 1 0 % of the total sale if the customer buys a beverage. b . If the beverage sale amount ( cell D 1 0 )...

Q:

J 1 0 to calculate the commission earned for beverages for order 1 . a . The beverage commission is 1 0 % of the total sale if the customer buys a beverage. b . If the beverage sale amount ( cell ( D...

Q:

Excel Homework 5 --- Fall 2017 Project Description: Project Description: In this project, you will apply the Excel skills you learned in Excel chapters 1 and 2. More specifically, you will be...

Q:

Howard has an account with a major shipping company to deliver all of their orders. This shipping company sends him a log of all shipments that were delivered each day. The log is a little bit...

Q:

Excel Homework 5 --- Fall 2017 Project Description: Project Description: In this project, you will apply the Excel skills you learned in Excel chapters 1 and 2. More specifically, you will be...

Q:

1 5 Use the LEN function in cell C8 to calculate the length of the "Text Stamp Phrase" in cell C7. 2 5 Use the SEARCH function in cell C9 to determine the position of the "#" symbol in the "Text...

Q:

what formula do i use in cell g9? it says "use the vlookup function in cell g9 to calculate the delivery price for order 1. the delivery price can be referenced on the "delivery information" lookup...

Q:

A parallel-plate capacitor is constructed from a layer of silicon dioxide of thickness 5 10-6 m between two conducting films. The dielectric constant of silicon dioxide is 3.8 and its dielectric...

Q:

RFL Inc., a Canadian-controlled private corporation, has a July 31 year-end. It is not associated with any other corporation. Its tax manager has estimated its 2019 federal income tax liability at...

Q:

$ 7 9 9 , 0 6 5 is the actual amount borrowed and the interest rate 5 . 8 4 % so calculate the following: Fortnightly payment in Years 6 - 1 0 if the interest rate is decreased by 0 . 7 0 % after 5...

Q:

This question is related to Rio Tinto, a mining company in WA. (You can use some information from the internet. However, your discussion must demonstrate valid and logical flow ideas). (a) Identify...