When the entire row is deleted, the formula that referenced cell D4 is no longer able to locate that cell, and it produces a #REF error in the spreadsheet. The next image shows what happens if row 4 is deleted. In column D we show the formula adding cells D3, D4, and D5 together, to get 75. The first image shows three numbers being added together (5, 54, and 16). To learn more, watch CFI’s free Excel course and follow the video instruction. #REF Excel Error Exampleīelow is an example of how you may inadvertently create a #REF Excel error. Every good financial analyst knows how to find and fix #REF Excel errors, which we will explain in detail below. An #REF error (the “ref” stands for reference) is the message Excel displays when a formula references a cell that no longer exists, usually caused by deleting cells that a formula is referring to.
0 Comments
Leave a Reply. |