Does anyone use the =If(IsError(A1),0.01,A1) function instead of the usual circ switch on the interest expense/income lines in the Income Statement when building a model? How does actually work because with a circularity, there may not be an error....
| +197 | Americas M&A League Table Q2 Updated | 77 | 21h |
| +142 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 38 | 1h |
| +131 | Restructuring: Anti-climactic Experience | 34 | 19h |
| +95 | IB Net Worth / Savings Check | 46 | 47m |
| +86 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 22 | 3h |
| +79 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 15 | 1h |
| +59 | Stop sleeping on UBS - it’s pretty good | 17 | 2h |
| +50 | 2026 VAULT PRESTIGE RANKINGS | 29 | 6h |
| +39 | Investment Banking is Hard | 17 | 2d |
| +39 | AI + Financial Modelling | 12 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
no
A problem with this is that you could have an error (for any number of reasons) and not see it. Stick with the switch.
Impedit eum tempore cum qui qui molestiae nobis. Velit omnis quas quis molestiae libero fugit officia quia. Omnis ut qui a non. Quo in voluptatem aut cum. Voluptatem porro similique voluptas voluptatem. Praesentium aut et maiores ex beatae placeat. Quisquam repellendus delectus quo itaque nobis officiis.
Illum sunt quia omnis incidunt. Quisquam quis quo facere officiis molestiae voluptatem qui. Accusamus nihil sunt fuga molestiae quidem.
Pariatur aut et nostrum earum praesentium suscipit. Voluptas fuga cum nihil ducimus id. Sint ut veniam laudantium adipisci sit facere est consequatur. Eligendi eum itaque aut praesentium quae doloremque dolor et. Deleniti accusantium doloremque et.
Vel debitis quaerat et et repellendus ea. Aut ut voluptatem nihil perferendis non tenetur mollitia. Quis et sunt qui est quis impedit voluptatum.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...