contestada

9. 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%.

Respuesta :

Parrain

Based on the formula being an IF function that tests total sales for being greater than a certain figure, the formula is =IF(B8>=1000000,B8*0.18,B8*0.10).

Why is this the formula?

If the amount in B8 is more than or equal to 100,000, the if function would be IF(B8>=1000000).

If the amount meets that criteria, then the IF function will multiply it by 18% and if the amount does not meet this criteria, the amount is multiplied by 10% after the third comma.

The complete formula would then be:

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

Find out more on the IF Function at https://brainly.com/question/25638609.

Otras preguntas