![]() Note that these formulas are also present in any document created from the Personal Budget template. If that's the case, you'll need to click twice on D11 to open the Formula editor, then enter B11-C11 in D11.Ĭell B11 should contain the formula SUM(B)Ĭell C11 should contsin the formula SUM(C) Row 11 is a Footer row, which may prevent the formula being filled into that row. ![]() This formula is filled down to D10, and is also used in D11 The same is true of the formulas in column D. If C2 does contain the formula, you can use the Fill control, a small yellow circle that appears on the bottom edge of cell C2 when you bring the pointer close to that location) to fill the formula into the rest of the cells in column C to C10. If this is the 'Actual' column, all cells should have the same formula as shown above, with A2 changing to match the row containing that copy of the formula. ![]() Working with either the original or the copy:Ĭheck the other cells in the column. (This is old-fashioned advice that considers the possibility you will not otherwise be able to access a backup copy of the file in its current state.) Start by making a duplicate of the document in its current state. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |