If I double-click on that cell to examine the formula, we can see that the formula subtracts the square of d steel from the square of d concrete. The area of the concrete section is a function of the steel diameter and the concrete diameter. Then I click the cell containing the zero for A concrete and click Trace Precedents: First, I’ll click Remove Arrows to clear this set of arrows. The term for the area of the concrete is in the denominator. We can double-click on the cell with the error to examine the formula. One of these cells is actually zero, so there’s a good chance that cell is actually causing the divide by zero error. Excel will draw arrows to the cells that are inputs: We can select the first cell with the #DIV/0! error and click Trace Precedents in the Formulas tab. It’s possible that one of these cells is causing the error. The first method is to trace the cell’s inputs using Trace Precedents. ![]() Troubleshooting Excel Formulas with Trace Precedents However, it’s generating divide by zero errors:Īlthough you could go through this calculation manually to find the source of the errors, I’ll demonstrate here how to use Excel’s troubleshooting tools.Īll the troubleshooting tools are in the Formula Auditing section of the Formula tab. This kind of structure is statically indeterminate, so the spreadsheet uses the consistent deformation method to calculate the forces in the steel and concrete parts. There is a uniform load applied across the top: The example spreadsheet shown throughout this post calculates the force in the components of a structure made of a steel bar encased in concrete. Excel has built-in tools that are very useful for troubleshooting formulas, even if the formulas are complex.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |