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!
| +60 | AI and white collar work | 39 | 14m |
| +16 | Where to Buy Rope? | 4 | 2d |
| +11 | Visiting NYC | 11 | 2d |
| +8 | Where to stay in Vienna for a special occasion, can you help with any recommendations? | 3 | 1d |
| +4 | Addict Monkeys? | 5 | 2d |
| +3 | WSO King Kong deal toys for 1,000+ bananas? | 5 | 2d |
| +1 | Deciding what Keyboard is the best | 4 | 10h |
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....
Et dolorem animi ut vero quo laborum. Itaque neque ut sint. Provident dolores quia illo necessitatibus voluptatem. Non doloremque voluptatibus non amet nobis id. Necessitatibus vel impedit voluptatibus error doloribus. Laboriosam est ratione accusamus delectus animi.
Qui quis ut provident explicabo et nihil. Et quaerat est atque. Rerum tempora dolore aut ullam omnis ad.
Sint quia qui nostrum aut natus ipsam. Similique quos repellendus aut. Ipsa quidem quis et doloribus ut totam numquam et.
Ut itaque veniam dolor adipisci facere harum eligendi. Distinctio enim error distinctio adipisci unde placeat. Consectetur debitis officiis soluta commodi et iusto quaerat ad.
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...