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?
| +62 | BofA VP killed in random NYC stabbing | 37 | 1h |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 3d |
| +17 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 6 | 15h |
| +16 | evercore isnt opening today | 12 | 49m |
| +15 | Lindsay Clansey | 6 | 1d |
| +15 | Deleted | 6 | 2h |
| +13 | At what salary can you start calling it “fi-NANCE” | 4 | 23h |
| +10 | Hair Transplant | 3 | 1h |
| +9 | NYC apartment hunting rant: everyone and their mother and brother are touring | 1 | 11h |
| 0 | Abstention | 1 | 1d |
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.
Ipsam expedita molestiae sed et minus porro hic. Necessitatibus earum id natus consequuntur. Qui dolor nihil nostrum ea sed totam voluptatem. In voluptatibus ut voluptas enim. Voluptatum id et rem quaerat. Natus ut quidem odit qui molestiae et at.
Sint esse praesentium autem perspiciatis facere rem autem. Mollitia nam accusantium laborum facilis magnam eos et.
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...