Why is this syntax used in Excel?
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!
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!
+99 | Fucking quit today | 28 | 2m | |
+86 | Waiting for a Girl | 34 | 10h | |
+79 | Finance Fiction Sub-Forum? | 17 | 2d | |
+69 | Are banking MDs happy with their life? | 21 | 15h | |
+68 | Remember to take care of yourself | 8 | 2d | |
+52 | Is it a bad idea not to save anything as a junior? | 28 | 4h | |
+35 | Staying Busy When Laid Off | 12 | 12h | |
+32 | Enron + Smartest Guys in the Room | 14 | 3d | |
+30 | Good jokes for interview? | 16 | 13h | |
+29 | NYC Social Clubs (Soho House & Others) | 9 | 2d |
Career Resources
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....
Qui incidunt commodi et iure magni. Occaecati laborum sit atque aperiam. Ad et laborum minima quaerat. Nihil maiores et illum cum quia voluptatem veritatis. Voluptatibus tempora ut quas totam.
Vitae voluptas velit laborum vel fugit rem. Vero delectus aperiam unde amet.
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...