You can copy this formula to cells D11-H11 to complete your change calculations. Type “=” to tell Excel that you are beginning a formula.Each formula in Row 11 is the result of subtraction using the “-” (hyphen) as a minus sign. Row 11 shows the change from the prior month. Row 9 displays the total of sales for all cities.Īre the sales increasing each month? If so, by how much? In this example, columns C through H show the sales for each month. Unfortunately, Excel doesn’t have a SUBTRACT formula. You need to subtract the prior month’s sales from the current month’s sales. Your boss asks you to add a row that shows the change from the prior month. You have created a report that shows your company’s sales by month.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |