You want to calculate agent commissions based on their role. In cell K12, insert the IFS...

You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent’s commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39.

Solutions

Expert Solution

Solution

Step 1

Go to cell K12

Step 2

Enter the following formula

=IFS(D12="BA",$L$7,D12="DA",$L$8,D12="SA",$L$9)

Step 3

copy the formula to K13:K39.

Please note

in case if percentage not appear

format it into

if you have any further doubt, please mention it

love to help

all the best

venereology answered 3 months ago

Next > < Previous

Related Solutions

EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is...

EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is greater than or equal to its average. Date Product Region SalesRep Customer Sales COGS Sum of Sales: 4/19/2020 Product3 Region3 SalesRep2 Customer16 $ 14,046 $ 5,337 4/19/2020 Product7 Region4 SalesRep15 Customer72 $ 2,504 $ 1,703 4/19/2020 Product2 Region4 SalesRep18 Customer71 $ 1,505 $ 843 4/19/2020 Product6 Region4 SalesRep14 Customer88 $ 4,232 $ 2,793 4/19/2020 Product3 Region4 SalesRep3 Customer65 $ 5,947 $ 3,390 4/19/2020 Product1...

1. If you want a hematopoietic stem cell to develop as a T cell the best...

1. If you want a hematopoietic stem cell to develop as a T cell the best approach is to: a. Have it develop in the bone marrow b. Make sure it expresses the Notch receptor c. Have it develop in the spleen d. Make sure it does NOT express the Notch receptor 2. All of the following with respect to B-cell development in the aging individual are true, EXCEPT: a. B-cell production swings more to the B-l group b. Aged...

51. For a cell based on each of the following reactions run at standard conditions, calculate...

51. For a cell based on each of the following reactions run at standard conditions, calculate the emf of the cell, the standard free energy change of the reaction, and the equilibrium constant of the reaction: Get the Potentials from the table of standard reduction potentials available on Blackboard) a) Mn(s) + Cd +2 (aq) ------> Mn+2 (aq) + Cd(s) c) 2 Br - (aq) + I2 (s) --------> Br2 (l) + 2 I - (aq)

I want an example that explains and calculate the kinetics rocket based on FBD by idealizing...

I want an example that explains and calculate the kinetics rocket based on FBD by idealizing the NASA space shuttle to a particle which has curvilinear motion. Assume the Earth is flat and state all other assumptions

Calculate the Ecell value at 298K for the cell based on the reaction Fe3+(aq)+ Cr2+(aq) -->...

Calculate the Ecell value at 298K for the cell based on the reaction Fe3+(aq)+ Cr2+(aq) --> Fe2+(aq)+Cr3+(aq) when [Fe3+] = [Cr2+] = 1.50x10-3 M and [Fe2+]= [Cr3+] = 2.5x10-4 M?

You want to analyze the potential effects of Cisplatin, a well known chemotherapeutic agent on E-cadherin...

You want to analyze the potential effects of Cisplatin, a well known chemotherapeutic agent on E-cadherin expression in ASPC1 cells at different concentrations (1, 3 and 10 µM). (15 pts) a. Name and explain at least 3 techniques you can use for this study in detail. b. What will be your test conditions for this study? c. With the below information already given to you, how many microliters of the drug will you add to each condition if you are...

If being a cancer cell was easy every cell would do it. Based on what you...

If being a cancer cell was easy every cell would do it. Based on what you learned from this course, using at least 3 distinct points, justify this statement. (5 points)

As a newly hired manager of a company that provides cell phone service, you want to...

As a newly hired manager of a company that provides cell phone service, you want to determine the percentage of adults in your state who live in a household with cell phones and no land-line phones. How many adults must you survey? Assume that you want to be 90% confident that the sample percentage is within 4 percentage points of the true population percentage. In a test of effectiveness of garlic for lowering cholesterol, 47 subjects were treated with Garlicin,...

Calculate E at 25° C for a galvanic cell based on the reaction: Zn(s) + Cu2+(aq)→Zn...

Calculate E at 25° C for a galvanic cell based on the reaction: Zn(s) + Cu2+(aq)→Zn 2+(aq) + Cu (s) in which [Zn2+]=0.55M and [Cu2+]=1.02M

Assume that you work in a cell biology lab and investigate the role of some biomarkers...

Assume that you work in a cell biology lab and investigate the role of some biomarkers in cell differentiation. Your advisor asked you to determine whether or not the cells that you have prepared in the lab has any potential to form stem cells. In previous experiments, other researchers have found that early biomarkers known as Oct4, Sox2, KLF4 and MYC were an indicator for stem cell formation. After you labelled your cells and counted the expression of these biomarkers...

Subjects