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
| +249 | Earliest you can get fired | 46 | 2h |
| +244 | UBS’s M&A BANKERS ARE DOING TERRIBLY. $200M EXTRA IS BEING CUT | 41 | 2h |
| +236 | Are target prospects getting dumber? | 44 | 2h |
| +227 | MBB Pay Raises | 47 | 2h |
| +212 | Career Crossroads | 25 | 2h |
| +207 | US 2027 SA IB worried about background check | 47 | 2h |
| +195 | Investment Banking is Divine | 33 | 2h |
| +192 | Analyst: Why is UBS IB doing worse than peers?, UBS CFO: No Comment | 38 | 2h |
| +191 | How do YOU manage networking requests? | 28 | 2h |
| +190 | Another $115bn Mega deal for these banks. Congrats! | 41 | 56m |
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
Suscipit accusantium voluptatibus omnis minima earum et. Rem incidunt odio est error hic illum molestias aut.
Laborum vel nesciunt nisi aut laboriosam delectus ipsam. Ad veniam optio nesciunt beatae error dolore at. A dolorem doloribus necessitatibus corporis veritatis eum.
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...