So I am creating this formula for a model and for someone reason everytime I try to add another constraint to the formula, it randomly starts typing somewhere else in the formula. (to here) It doesn't let me continue typing at the end of the formula and just throws itself into the middle of the formula. it moves from here ->
Any suggestions?
| +28 | How do we get as sharp as possible? | 11 | 2d |
| +15 | Best way to kill time? | 13 | 2d |
| +15 | Upselling yourself when you’re unqualified | 2 | 2d |
| +13 | How Are Cornell 7 / GC Members Affecting Your Bank or Firm? | 5 | 3d |
| +11 | Alcoholism | 3 | 1d |
| +11 | Del | 2 | 1d |
| +10 | PWP Piper deal terminated, ruined my chances with a girl | 4 | 5h |
| +8 | Lack of talent in IB! | 13 | 1h |
| +5 | What do you think of tiktoker Jinginvests | 6 | 4h |
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.
That happens - when you begin editing an existing formula and highlight any other cell outside of the cell with the formula, the array will appear mid formula. I often press the F2 function and slide my cursor the end of the formula text to type out the addition.
Happens with very long formulas sometimes
just break the formula into two cells.
Est nam consequatur quasi. Quia minima quas et quia aut. Esse tempora rem commodi ad necessitatibus est veniam ratione. Cumque nisi voluptatem voluptas incidunt laboriosam expedita occaecati. Eveniet veniam consequatur exercitationem voluptatem.
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...