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 $ or more in a month, the dividend is of the sales. It the company earns less than $ in a month, the dividend is of the sales. Calculate the dividends as follows:In cell enter a formula that uses the IF function and tests whether the total sales for January cell is greater than or equal to bIf the condition is true, multiply the total sales for January cell B by to calculate a dividend of If the condition is false, multiply the total sales for January cell B by to calculate a dividend of dUse the Fill Handle to fill the range C:G with the formula in cell 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
