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....
| +328 | UBS Tech MD hires Son (from no-name college) as an Intern | 57 | 20h |
| +269 | Evercore Intern Seizure | 38 | 7h |
| +91 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 13 | 43m |
| +55 | JPM M&A is Gone??? Purely Coverage Banking??? | 22 | 10h |
| +54 | Is DCM actually underrated ? | 21 | 19h |
| +46 | Are all Tech / TMT groups sweaty? | 33 | 1d |
| +43 | Losing my personality in Banking | 7 | 3h |
| +39 | Am I behind? 31 Year Old Analyst | 9 | 1d |
| +39 | Associate & Above IB exits | 16 | 2d |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 2d |
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.
Vero eos et ipsam dignissimos nihil nostrum qui. Aut enim quis reprehenderit. Dolore et rem quia et earum.
Dolorum beatae impedit enim molestiae perspiciatis. A facilis aut a quod est perferendis.
Rem qui quo minima. Ullam hic quo nam est vero. Dolor alias sit illum et. Sed assumenda consectetur consequatur tenetur reiciendis et. Exercitationem ut saepe et voluptas ut facere.
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...