Spaces in Excel Formulas
Is there a best practice surrounding this or is it just personal preference?
Ex. =SUM(A1:10, C1:C10) or =SUM(A1:A10,C1:C10)
Trending Content - Investment Banking Forum
| +211 | Just One More Year | 17 | 4h |
| +172 | Piper Sandler in talks to acquire PWP | 74 | 5d |
| +124 | UBS Appears to be Exploring Sale | 19 | 2d |
| +87 | Paradise Is Paradise | 8 | 9h |
| +77 | Drunk VP. How to manage? | 27 | 1d |
| +38 | How do I take my foot off the gas? (AN1) | 4 | 1d |
| +38 | Lazard US Views 2026/2027 | 13 | 1d |
| +32 | M&A is Paradise | 1 | 6d |
| +25 | Why did EVR succeed vs GHL or PWP that ended up getting acquired? | 7 | 3d |
| +24 | HR is starting to worry me, do I throw a hail mary during an upcoming chat with an MD? | 4 | 51m |
Career Resources
Big space energy guy.
I have never seen anyone put spaces in an excel formula, suspect you will get weird reactions if you do.
Psycho behavior
Lol what
If you put spaces in your excel formulas I will personally dox you, find you and bitch slap you for being weird.
spaces make formulas much more readable with almost no effort
clearly no one here has ever touched a programming language
Fair point, but in IB you are very rarely reading formulas - main way to check stuff is by tracing. There's no programming used in ib anyway
sure, I dont think the difference is big enough that id care about other ppl using them
Proper naming for relevant cell / ranges makes reading formulas easier, spaces don’t. When I audit formulas, the formula bar is the last thing I’m looking at. Leave spaces on a file I’m working on and I’ll bitch slap you
if you never look at the formula bar why would you care if someone uses spaces?
They actually do, because we make each other’s lives easier by not doing stupid shit such as leaving unnecessary spaces within formulas
I personally wouldn't look or care if someone used spaces. it just is inefficient hitting space that many times
(i) I was being sarcastic (ii) it's a really stupid thing to do. There are best practices and for your own benefit you should conform to how things are done. Don't try to reinvent the wheel unless you can add value by making a process / task more efficient. The analyst crashes the model? I can figure out how to fix it. The backup is messy? If what I'm looking for is there, I'll find it. Albeit inefficiencies make my job more time consuming.
The takeaway here is as follows: as a junior banker when presented with a task or when taught something that you disagree with, ask yourself two questions (i) is my disagreement a matter of preference? and (ii) am I being told to something that - after asking follow-up questions and reading up on it - I believe is materially incorrect?
If the former, do as you are told. That will save you a lot headaches throughout your career. If the latter, speak up.
Spaces are inefficient, you waste time adding them and they don't have a purpose in excel
Because OP is ~not like the others~ he's so quirky and different bro
Quis facere optio enim aspernatur. Nulla expedita rerum doloribus quia non aut aut velit. Et qui saepe explicabo accusamus nulla. Ea et minus dolor cum expedita necessitatibus in. Voluptas itaque est expedita aperiam est quasi. Officiis provident ipsa incidunt minus sapiente.
Odio dolorem dolorem et eaque distinctio explicabo. Impedit voluptatem accusantium architecto minima non. Aut facilis est autem ea numquam tempora voluptatum recusandae. Incidunt qui ut nemo earum voluptate quis commodi ut. Ut qui in nam.
Dolor officia non sed incidunt aut vel. Nihil illum est adipisci voluptatem hic molestiae nisi.
Quod quos consequatur ratione doloremque non a laudantium placeat. Laudantium natus sint nisi nostrum voluptate cupiditate.
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...