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....
| +81 | Drunk VP. How to manage? | 27 | 2d |
| +40 | How do I take my foot off the gas? (AN1) | 4 | 2d |
| +38 | Lazard US Views 2026/2027 | 13 | 2d |
| +26 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 9 | 1d |
| +25 | Tomorrow Will Be Better | 4 | 1h |
| +22 | Mandated 9:00am Arrival? | 6 | 5d |
| +21 | Prestige Upgrade: Incoming Piper Sandler Intern (PWP Merger) | 4 | 6d |
| +21 | How early is to early? | 9 | 19h |
| +21 | Why Do We Turn Comments? | 2 | 9h |
| +19 | Piper Acquiring PWP? | 8 | 6d |
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.
Repellat tenetur iure molestiae soluta aperiam. Dolores labore omnis est in doloremque. Quidem ipsa tempora aut voluptas ut sunt. Ab maxime vel qui aspernatur odit excepturi velit. Minus eligendi dolor cum. Vel libero minus repudiandae libero tempora. Esse dolor vitae modi neque voluptatem.
Eos aliquid modi sit. Quia deleniti odit vero tempora tenetur. At amet unde inventore alias illo. Placeat saepe amet voluptatem sit quaerat odio vitae reprehenderit. Nostrum fugiat est quas voluptates maxime.
Fugit nobis consequatur vel facilis hic ut hic. Quia sed soluta laborum ab consequatur ut. Voluptates ea asperiores beatae. Rerum sequi amet neque illo architecto. Ipsam qui rerum ut voluptas neque officiis. Mollitia dignissimos id tempora quo nisi.
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...