formaula problem

Here is a further explanation of the above formula using actual data. Looking at the screenshot below, for the North region, the “First Quarter Total” is 31,000. The “Total” for the second quarter is 49,650. So you will subtract the cell that contains 31,000 from the cell that contains 49,650 to get 18,650. Then divide that result by the cell that contains 31,000 to get 60.16%. This means that the second quarter revenue total has increased from the first quarter revenue total by 60.16%. Be sure to change the cell format for the final results in the cell to a percentage. Lorraine final project.xlsx