EXCEL COURSE PART ONE - FORMATTING A DATABASE

Re-open the workbook that you just closed. Use the Goal Seek command to determine the margin percentage (cell B21) that would result in a semiannual operating income of $45,000,000 in cell H16. Click the What-If Analysis button on the Data tab on the Ribbon to access the Goal Seek command. You should end up with a margin percentage of 59.04%. ................
................