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....
| +335 | Return Rates For Interns Are Falling? | 142 | 46m |
| +148 | Article: Why UBS's Asian M&A bankers are thriving and UBS's American M&A bankers are not | 17 | 5h |
| +144 | Evercore > Goldman and I don’t think it’s particularly close anymore | 56 | 5m |
| +124 | I am a drunk MD AMA | 40 | 1d |
| +86 | UBS Offer Day | 30 | 22h |
| +75 | Santander IB? | 10 | 3d |
| +68 | I hate Wells Fargo | 19 | 7h |
| +51 | No return offer - feeling like a failure is an understatement | 20 | 2h |
| +45 | How cooked am I as an incoming WF IB SA 2027? | 17 | 28m |
| +43 | WF Return offers | 28 | 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.
Molestiae ducimus ut iusto molestiae fugit aliquid iste. Sapiente necessitatibus aut officia non error suscipit in.
Eligendi atque vero non consectetur. Possimus et corporis repellat odit rerum nihil. Tenetur est exercitationem quas dignissimos.
Qui quas voluptatem voluptatem exercitationem ipsa vitae. Tempore et vero commodi autem et rerum. Sunt mollitia quo praesentium ratione magni omnis dolor alias.
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...