The problem is that the balance formula in row 3 is still referencing the balance from row 2. In this example, a new row was inserted above row 3 and the balance formula was then copied down. Problem #2: Inserting a Row Causes an Incorrect Running Balance ![]() While annoying to fix, it's not as scary as the errors that are harder to detect. This error is very obvious, and can be fixed fairly easily by fixing the balance formula in row 3. All dependent formulas also contain #REF! errors. The balance formula in row 3 now contains a #REF! error because the reference to the balance in row 2 was deleted. ![]() Problem #1: Deleting a Row Causes a #REF! Error Another approach is to leave a blank row underneath the columns labels, or use the first row to enter the carry over balance instead of using a formula. ![]() NOTE Why use SUM instead of =D15-E15+F14? Answer: The formula in the first row would lead to a #VALUE! error because of trying to add a text value (=5-1+"Balance").
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |