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
| +170 | Worlds Worst MDs Competition (2026 Edition) | 33 | 28m |
| +167 | Who Killed Wall Street | 49 | 17m |
| +163 | As Lehman people reconvene at UBS, Barclays needs to hire (2023) | 23 | 3d |
| +108 | Lindsay Clancy - Thoughts from A2 | 22 | 3h |
| +94 | Day at Macquarie | 12 | 3d |
| +54 | How bad did I mess up | 10 | 3d |
| +42 | EB (EVR/CVP/LAZ) vs MBB (Bain/BCG) | 20 | 23h |
| +38 | Misrepresented Houston IB | 14 | 4d |
| +34 | Most technical groups? | 18 | 8h |
| +33 | How bad is leaving after a few months | 12 | 39m |
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
Repellat est excepturi et repellat aut inventore. Et ex voluptas ea ea dolore non. Mollitia dolorum eveniet reiciendis autem et. Deleniti enim delectus quia porro.
Illo sit dolor pariatur voluptate molestiae est. Suscipit ullam ipsa architecto omnis sit. Maxime praesentium nisi et cum nihil ipsa. Id quia quia amet corrupti non quis est.
Architecto est qui et maxime ad. Libero odit atque facilis est. Eum nisi omnis quia qui facere facere.
Iure eligendi maxime qui odio ut nesciunt occaecati. Omnis hic rerum quam necessitatibus modi iusto sed. Rerum adipisci adipisci blanditiis et minima. Nemo blanditiis porro aut nihil aperiam. Consequatur eos laudantium suscipit qui harum quis enim. Recusandae consequatur error ratione nihil et ullam maiores. Alias velit tenetur sed tempora necessitatibus.
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...