ferrobali.blogg.se

The scary thing about this example is that there is no obvious indicator of the errors.

In this example, row 3 was cut and inserted above row 2. Problem #3: Moving a Row Causes Hard-to-detect Errors It isn't wise to rely on the error checking feature because it doesn't catch all errors. In this case, a little green triangle indicates an inconsistent formula. The error checking feature in Excel was designed to help identify these types of errors. 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").