I've only started to recently notice this but why do some Excel models have "+" signs at the beginning of formulas? Ie: =+G21. The "-" sign obviously makes sense but is there any value to putting "+" signs in front of formulas if the result is automatically going to be a positive number anyway? Am I missing something here?
| +374 | Which Offer to Accept: UBS Analyst Role or Part Time Cashier at the Local Taco Bell | 44 | 6h |
| +291 | Roku-Fox Deal - UBS Misses Out on yet another deals after years chasing this deal | 31 | 6h |
| +272 | TPH V.S. Mizuho [HOU] | 33 | 2h |
| +270 | AI is insane | 38 | 2h |
| +268 | I Snuck Into UBS Office And Took A Shit On The Floor | 26 | 9h |
| +220 | Best Power/Renewables/Energy Teams? | 35 | 4h |
| +202 | Useless associates | 36 | 5h |
| +184 | Differences in Restructuring Teams? | 33 | 6h |
| +181 | Centerview HC group falling off? | 28 | 6h |
| +181 | Actual EB List | 26 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
You can use the plus instead of equal to input a formula, it’s easier with a ten key to do it that way.
I believe that's what the older excel-like programs used to use, and it's a hold-over from that time - these days some people just think its faster.
It is faster. If you have a 10 key then you are able to create excel formula calculations (especially when quickly calculating quick arithmetic with just numbers or a formula that starts with a number i.e., +3*9-2 or +3*Cell-2) with only your right hand. Excel needs something to know it's a formula and the "+" key on the numpad is faster than using "=" in the number row (as you would have to move your hand or use both hands to execute either of the above two numbers). Coming from someone in banking almost 10 years and have never used the "older excel-like programs" you're referring to.
To answer the OP's question on why it is =+ instead of + sometimes is I believe excel will auto update some excel formulas to have the = sign in front -- don't quite remember what triggers it (best guess from memory would be one of the FactSet add-ons doing it) but that's why my formulas will end up with a =+ instead of just my + I inputted.
normally there's no equal sign on the numpad (there is a plus and minus) and some people like to use their numpad since it's faster than the top keys. something i need to start working on
Makes no formulaic difference, just a tiny bit faster to type and you don't have to reach all the way up the keyboard
IMO a lot of bankers see this in models when they're starting out and switch to it, regardless of whether they actually use the numpad or not
It's a hold-over from this ancient spreadsheet program called Lotus 1-2-3. Microsoft included that functionality in Excel to help Lotus users make the switch to a new software platform. I use it fairly frequently on a regular keyboard with a number pad for scratch calculations or formulas that are just arithmetic between cells because its close to the arrow keys.
Damn, are you the world's oldest IB intern? Not a diss in any way, because if you are, you probably have a pretty interesting life story but don't know of many 21 year olds who know what a floppy disk looks like, let alone Lotus 1-2-3
Going to be a 31 year old SA so not sure if I'm the oldest ever, but I'm probably up there. It has been a wild road, but I am so glad I finally made it.
Nesciunt culpa placeat accusantium et animi libero occaecati. Necessitatibus dolor facilis aliquam et. Et molestiae nihil aliquid neque quasi facilis labore soluta.
Quam accusamus deleniti fugit vero est. Et aut vel cupiditate optio nam illum eligendi. Et vel quam magnam laudantium velit distinctio in a. Inventore ut a in numquam laborum et eos. Quo quia sit minus a ab.
Natus excepturi eum vitae in nesciunt harum. Nesciunt architecto ut debitis recusandae. Ducimus asperiores assumenda at repudiandae officia. Architecto perspiciatis eos modi enim nam distinctio vel. Corporis asperiores quasi esse delectus architecto voluptatum provident. Animi nihil quas ea ipsum necessitatibus.
Doloribus asperiores officia quos fugit necessitatibus quia. Consectetur tenetur quae minus id rerum. Voluptatem adipisci voluptatem dolor eos et. Adipisci aut odit aliquid eius hic error. Consequatur dolores temporibus exercitationem saepe.
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...