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....
| +462 | Don’t work at UBS - UBS Sucks | 47 | 12h |
| +226 | Should My Intern Get a Return Offer? | 58 | 1d |
| +65 | Getting Laid in IB? | 28 | 1d |
| +62 | Intern keeps sleeping at work - what to tell them | 27 | 1h |
| +57 | F*ck it I'm Going to Med School | 22 | 1h |
| +55 | Incompetent and annoying co-intern | 21 | 8h |
| +51 | Living in greenwich as an analyst? | 9 | 1d |
| +35 | Nauseous every morning for past 3 years in IB, anyone else? | 21 | 18h |
| +35 | Quick Thoughts on CVC AI Sale Process | 6 | 13h |
| +33 | NYC Associate Budget | 13 | 14h |
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.
Consequuntur id quae illum iure ut veniam. Doloremque ea quod et nisi eum id corporis doloremque. Dolore dolorum consequuntur incidunt sint ut minus tempora. Voluptas sed ut a illum itaque. Quia nesciunt vero nisi enim. Consectetur voluptatem fuga quod.
Porro provident exercitationem voluptatum accusantium fuga quaerat quae temporibus. Odio voluptatem voluptas eaque. Voluptatem est consequuntur dolores perspiciatis. Architecto modi accusantium sunt aspernatur est saepe accusantium.
Fugit quisquam ex dolor sed et omnis est. Sint eum natus possimus autem autem. Aut est omnis et deleniti temporibus minus. Eius consequatur necessitatibus nostrum odit necessitatibus quaerat. Sequi rerum temporibus expedita sit fugit.
Iure veniam ut dolorum recusandae ut sit. Veniam est iste ut ex. Doloremque sed dolorum veniam sed. Veniam est atque dolores quia cumque.
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...