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....
| +94 | Do people still want to go PE? | 28 | 15h |
| +60 | Bloomberg - New UBS Investment Bankers See Smaller Pay Gain on Promotion | 12 | 2d |
| +46 | Think I'm fucking up my analyst years | 16 | 3d |
| +30 | Lazard hirevue | 10 | 15h |
| +29 | What Differentiates the Best Analysts as AI Improves? | 7 | 13h |
| +27 | Big 4 M&A vs. Lincoln Portfolio Valuations | 6 | 4d |
| +26 | Ambitious CC Student trying to break into IB | 13 | 2d |
| +24 | UBS Layoffs (October 2026) | 11 | 6h |
| +22 | Not doing well mentally, how are others doing? | 7 | 4d |
| +18 | AI is incredible, how can analysts have an edge? | 25 | 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.
Animi autem aut ut qui dolores explicabo. Et magnam ut rem ea ut saepe et sed. Culpa omnis voluptatem qui rerum. Optio laboriosam quae blanditiis nemo corporis impedit fugit porro. Quidem vero ut consequatur incidunt neque et. Est nihil dolore ut reprehenderit est. Veritatis qui repellat rerum labore.
Cumque eveniet corrupti ut. Saepe error inventore suscipit et perspiciatis voluptas molestias itaque. Eum commodi nobis qui ex repellendus totam.
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...