(In cell B15, enter a formula that uses the IF function and tests whether the total...

(In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.)

Expert Solution

IF function in excel is used to test a condition and return a value if it is true and return another value if it is false.

So, now let us see the syntax of IF function,

=if(logical_test,true_value,false_value)

The logical test and the values are separated by comma

Now in this question, the logical test is to check whether the value in cell B8 is greater than or equal to 1000000.

=if(B8>=1000000

Next we have to give the return value if the condition is true. Here if the condition is true then the value in B8 is multiplied by 0.18

=if(B8>=1000000,B8*0.18

Next comes the return value if the condition is false, here we have to multiply B8 by 0.10

=if(B8>=1000000,B8*0.18,B8*0.10)

We have to calculate this value in cell B15. So the above formula should be entered in cell B15

I have provided the sample output with sample values.

venereology answered 1 day ago

7.In cell N2, enter a formula using the IF function as follows to determine which work...

7.In cell N2, enter a formula using the IF function as follows to determine which work tier Kay Colbert is qualified for: a.The IF function should determine if the student's Post-Secondary Years is greater than or equal to 4, and return the value 2 if true or the value 1 if false.

On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the...

On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the total gross sales for records visible in the table. Format as Accounting. In cell B2(Average Gross Sales), enter a function that will calculate the average gross sales for records visible in the table. Format as Accounting. In cell B3 (Total Movies) enter a function that will calculate the number of movies visible in the table, using the MovieID field. Total Gross Sales (filtered) Average...

In cell C6 in the Summary sheet, enter a nested IF function to determine which city...

In cell C6 in the Summary sheet, enter a nested IF function to determine which city had the highest temperature. Based on the result returned in B6, enter the city name as OKC or Tulsa or Lawton in C6. Remember to enclose city names in double quotation marks in the function. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column.

*Create a python function that uses a while list to allow a user to enter values...

*Create a python function that uses a while list to allow a user to enter values for sales and to add each value into a list in order to track all values entered. Set the gathering of values to stop when the value of zero is entered. Then take the created list and calculate the values within the list to return the total for all the values. Next, take the previously created list and display all the values from smallest...

insert an If function in cell 5 to calculate the total due, if the student has...

insert an If function in cell 5 to calculate the total due, if the student has chosen to personalize the ring there is an additional charge of 5% located in cell B12 that must be applied: if not the student only pays the base price. Use appropriate relative and absolute cell references in excel

A) enter the formula for the conjugate base of HCO3- B)enter the name for the conjugate...

A) enter the formula for the conjugate base of HCO3- B)enter the name for the conjugate base of HCO3- C)enter the formula for the conjugate base of H3O+ D)enter the name for the conjugate base of H3O+ E)enter the formula for the conjugate base of HPO4^2- F)enter the name for the conjugate base of HPO4^2- G)enter the formula for the conjugate base of HNO2 H)enter the name for the conjugate base of HNO2

On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.

Mortgage InformationAnnual Interest Rate4.90%Repayment Years30Price of House$275,000Down Payment$55,000Principal of LoanMonthly PaymentsOn the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assume that payments are made at the end of...

write a C++ program that uses function swap (a,b) to enter two real numbers from the...

write a C++ program that uses function swap (a,b) to enter two real numbers from the keyboard and uses function min_max(a,b) to return a to be the smaller of the two numbers entered always.

write a C++ program that uses function swap to enter three real value from the keyboard...

write a C++ program that uses function swap to enter three real value from the keyboard and outputs there in order from minimum to the maximum. For example 10,100,30 if were entered then the output would be 10,30,100. The program should use function get_data(a,b,c) and print_data(a,b,c)

What are the uses of compaction tests?

Question