In cell B17, you can enter the following formula that uses the IF function:
=IF(B10>=200000, B10*0.35, B10*0.27)
This formula will test whether the total sales for January (cell B10) is greater than or equal to 200000. If the condition is true, it will multiply the total sales for January by 0.35. If the condition is false, it will multiply the total sales for January by 0.27.
To fill the range C17:G17 with the formula in cell B17 to calculate the dividends for February through June, you can use the Fill Handle. Simply click and drag the fill handle located in the bottom right corner of cell B17, and drag it across to fill the range C17:G17 with the formula. The formula will automatically adjust for each cell in the range, using the corresponding total sales for each month.
In cell B17, enter a formula that uses the IF function and tests whether the total
sales for January (cell B10) is greater than or equal to 200000.
b. If the condition is true, multiply the total sales for January (cell B10) by 0.35 to calculate a dividend of 35%.
C. If the condition is false, multiply the total sales for January (cell B10) by 0.27 to calculate a dividend of 27%.
d. Use the Fill Handle to fill the range C17:G17 with the formula in cell B17 to calculate the dividends for February through June.
5 answers
Why does Lady Capulet want Juliet to go to the masquerade ball?
Lady Capulet wants Juliet to go to the masquerade ball because it is an important social event and an opportunity for Juliet to meet potential suitors. Lady Capulet believes that it is time for Juliet to start thinking about marriage and finding a suitable husband. Attending the ball would allow Juliet to socialize with eligible young men and potentially make a favorable impression on them. Lady Capulet sees the ball as a chance for Juliet to begin her journey into adulthood and explore her options for a future partner.
Rephrase it to prek
Lady Capulet wants Juliet to go to the masquerade ball because it is a special party where Juliet can have fun, meet new friends, and dress up in a beautiful costume. Lady Capulet thinks it would be a great experience for Juliet to attend the ball and enjoy herself, while also maybe meeting someone special or creating happy memories.
1 answer