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?
| +95 | Are you “less ambitious” for having long term goals outside of NYC | 24 | 4h | |
| +37 | Interviews Are So Fake | 24 | 4h | |
| +33 | 2024 UK Election - Tories finished? | 20 | 15h | |
| +29 | Being Christian in investment banking | 14 | 10h | |
| +26 | Is my boss gaslighting me? | 3 | 6d | |
| +24 | Non-Competes Banned | 16 | 1h | |
| +22 | Ideas for things to do with a free semester before starting ft? | 9 | 1d | |
| +20 | Sabotaging Peers to Get Ahead? | 34 | 3d | |
| +18 | Best NYC neighborhood for single 30M | 12 | 1d | |
| +17 | Moelis has the cutest Analysts? | 4 | 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.
Dolores praesentium perferendis vitae et reiciendis et. Consequatur ea fugit dignissimos.
Eveniet omnis reprehenderit debitis dolores et. Porro vero blanditiis ducimus doloremque accusamus aut aut. Dolores omnis iure dolorum perspiciatis enim quisquam ut ut. Adipisci doloribus et laudantium voluptatibus odio exercitationem.
Velit cumque ea voluptate facere a velit aliquam et. Alias sed aut voluptatem provident exercitationem.
Qui doloremque laboriosam impedit inventore earum mollitia et magni. Molestiae recusandae nisi dolorem ut quibusdam voluptates. Recusandae ab et et sit ipsam rerum quod aut. Ut est provident velit.
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...