I was reviewing an Excel spreadsheet, and I noticed someone did this
=+I8-+I$6 -- What does the + do?
IE. versus =I8-I6 ... What's the difference? Thanks!
| +61 | BofA VP killed in random NYC stabbing | 38 | 50m |
| +46 | What Bank Will Make Women Instantly Fall In Love With Me? | 14 | 3d |
| +17 | Western Investment Bankers Deserve No-Minimum-Wage Nannies, and I Want Mine NOW | 6 | 18h |
| +17 | evercore isnt opening today | 12 | 4h |
| +16 | Lindsay Clansey | 6 | 1d |
| +15 | Deleted | 6 | 5h |
| +13 | At what salary can you start calling it “fi-NANCE” | 4 | 1d |
| +13 | Hair Transplant | 7 | 51m |
| +11 | NYC apartment hunting rant: everyone and their mother and brother are touring | 2 | 3h |
| 0 | Abstention | 1 | 1d |
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.
If I$6 is negative the formula will change it to a positive value before subtracting. Try it out with some #s.
Edit: Also sometimes for the first plus I will hit "+" on the keypad to start a formula because it is faster than hitting "=" then moving your hand over to the keypad.
Really? Doesn't do that in my Excel, so the extra "+" just seems useless.
Yeah it's the same as "=", but is a habit from whatever Excel's predecessor was. A lot of our older people here use it which is really annoying. Also can be a timesaver like DFF said - start a formula with it and you don't have to leave the num pad.
Old people formulas
yeah i never got that either. i would just use abs() obviously if you want a number to always be positive....
Consequatur perspiciatis aut nam explicabo aut. Commodi minima facere in quia. Vitae velit sit molestiae. Necessitatibus reiciendis molestiae quia veniam consequatur.
Reprehenderit sunt culpa corporis debitis. Velit eos tempore inventore eligendi illo. Sed eaque velit qui beatae est error eum. Saepe consequatur fugit qui velit quis culpa et.
Est omnis provident qui qui a. Recusandae aut dolores perspiciatis delectus. Eaque porro fugiat quis animi nam. Rerum et doloremque error praesentium enim.
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...