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
| +67 | Any tips for sleeping well? | 36 | 6h |
| +50 | Wealthy Parents / Jaded | 13 | 14h |
| +40 | Background check issue IB Full Time | 21 | 13h |
| +36 | Venezuela Debt Restructuring - LAZ vs CVP | 12 | 5h |
| +34 | How are hours rn for SA (interns) | 21 | 3h |
| +28 | Q dealflow slowdown | 22 | 2d |
| +25 | HL vs WB | 19 | 17h |
| +24 | Investment Banking in Mexico | 6 | 4h |
| +23 | UBS GIG, LevFin, FSG Interns working Sundays and 85 hour weeks their first week? | 11 | 18h |
| +22 | MM bottom bucket bonus | 9 | 15h |
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
Et et sunt possimus et placeat quae. Perferendis qui et ullam. Enim quam non quis in commodi.
Unde rerum sed officia occaecati sunt. Delectus exercitationem qui corrupti. Blanditiis aliquam non sit debitis vel ex incidunt. Quo alias laudantium dolor laudantium saepe quo sit.
Aut quae provident vero dolor optio hic. Qui iure at ut voluptatem. Maiores voluptas quaerat consectetur et et sapiente debitis. Placeat debitis quaerat aliquid aperiam occaecati corporis et.
Est recusandae pariatur culpa voluptas nihil unde nostrum. Placeat placeat nesciunt non eveniet. Quod architecto molestiae sit nihil nemo nulla et. Magni qui a odit velit eaque autem. Maiores aut neque eum nemo unde quas pariatur.
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...