Question: Alexi also needs to calculate the dividends earned each month. If the company earns $ 2 0 0 , 0 0 0 or more in

Alexi also needs to calculate the dividends earned each month. If the company earns $200,000 or more in a month, the dividend is 30% of the sales. It the company earns less than $200,000 in a month, the dividend is 25% of the sales. Calculate the dividends as follows:In cell 825, enter a formula that uses the IF function and tests whether the total sales for January (cell 810) is greater than or equal to 200000.b.If the condition is true, multiply the total sales for January (cell B10) by 0.30 to calculate a dividend of 3096.If the condition is false, multiply the total sales for January (cell B10) by 0.25 to calculate a dividend of 2596.d.Use the Fill Handle to fill the range C25:G25 with the formula in cell 825 to calculate the dividends for February through June.

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 Programming Questions!