Question: HELP! what do i type in the excel formula to do what the instructions are asking for 8. a. c. 9. Lindsey wants to determine

HELP! what do i type in the excel formula to do what the instructions are asking for
HELP! what do i type in the excel formula to do what
the instructions are asking for 8. a. c. 9. Lindsey wants to

8. a. c. 9. Lindsey wants to determine how the sales of each month contributed to the total sales. Calculate this information for her as follows: In cell B13, insert a formula without using a function that divides the total sales for January (cell B10) by the total sales to date (cell 110). b. Use an absolute reference to cell 110 in the formula. Use the Fill Handle to fill the range C13:G13 with the formula in cell B13. Lindsey also needs to calculate the dividends earned each month. If the company earns $200,000 or more in a month, the dividend is 35% of the sales. If the company earns Yess than $200,000 in a month, the dividend is 27% of the sales. Calculate the dividends as follows: 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%. 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. a. C. AutoSave OF Home Insert Draw Page Layout Formulas Data Review Tell me View Wrap Te Calibri (Body) BIU Paste Jorge Open recovered workbooks? Your recent changes were saved. Do you want to continue working wher . x fx =1F(810,

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