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
| +413 | Change My Mind: Banks Shouldn’t Hire Foreigners at All | 111 | 2h |
| +208 | Article - UBS’ Investment Bank Keeps Losing Ground | 34 | 11h |
| +103 | Don’t work at UBS - UBS Sucks | 13 | 1h |
| +80 | An Exhaustive Guide: How to Solve Every Single Accretion/Dilution Question | 7 | 4h |
| +52 | When to Leave Office as Intern | 6 | 32m |
| +43 | Best IB Group Overall? | 25 | 1d |
| +34 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 2d |
| +31 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 22 | 1d |
| +31 | STEM student lost in London IB recruiting | 17 | 21h |
| +20 | Still recruiting SA'27 | 13 | 20h |
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
Itaque cum sunt et est nobis. Eveniet tempora eaque vitae ex autem ab nemo. Possimus modi possimus numquam. Odio iste sit autem ipsum repudiandae quam commodi. Provident sunt ut ut aliquam est. Incidunt tempora veritatis maxime ipsa. In sint quisquam autem earum sapiente autem.
Dolores ipsum et ex error atque non. Rerum sint est nihil. Voluptas quod ea necessitatibus perferendis quo cupiditate. Culpa perspiciatis sapiente ab quasi earum doloribus. Facere autem praesentium nisi quae facilis autem. Ab nulla magni voluptatibus dignissimos praesentium id blanditiis. Quasi aut recusandae dolores velit.
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...