If you can't find the error, click the Formulas tab, click the arrow next to Error Checking, point to Circular References, and then click the first cell listed in the submenu. If this confuses you, imagine what it does to Excel. They happen when you put a formula in cell A1, and it uses another formula in B1 that in turn refers back to cell A1. While you're looking, check for indirect references. ![]() Formulas like =A1+1 (in cell A1) also cause circular reference errors. For example, cell A3 might contain the formula =(A1+A2)/A3. ![]() If you just entered a formula, start with that cell and check to see if you refer to the cell itself. You can also try one of these techniques:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |