212k views
4 votes
In the Combined Sales worksheet, correct the formula in the cell range D3:D7 so that it calculates the percentage of change from Sales 2010 to Sales 2011.

1 Answer

3 votes

Final answer:

To calculate the percentage of change from Sales 2010 to Sales 2011, use the formula ((Sales 2011 - Sales 2010) / Sales 2010) * 100.

Step-by-step explanation:

To calculate the percentage of change from Sales 2010 to Sales 2011 in the cell range D3:D7, you can use the following formula:

=((Sales 2011 - Sales 2010) / Sales 2010) * 100

This formula subtracts the Sales 2010 value from the Sales 2011 value, divides the result by the Sales 2010 value, and then multiplies by 100 to get the percentage of change. Make sure to replace 'Sales 2010' and 'Sales 2011' with the actual cell references for those values in your worksheet.

User Tenub
by
8.1k points