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?
| +102 | KISSED MY VP… HELP!!! | 16 | 1d |
| +27 | How expensive is SF? | 14 | 4d |
| +13 | Give me all your ideas | 2 | 7h |
| +9 | Morning or evening for gym time? | 12 | 3h |
| +7 | Does SpeedX China Accelerator Really Work | 1 | 1h |
| 0 | What is a tool that you wish you had and would use every day? | 3 | 3d |
| 0 | ib with coc clan leader background? | 2 | 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.
Vero doloribus et et in. Sint quam eum ad optio odio officia. Qui porro et doloremque tempora omnis voluptatum.
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...