=+(NUMBER OF CELL) IN A CELL, WHAT DOES IT MEAN?example =+D101

[AB]

in a spreadsheet done by x coleague she had a formula in cell as =+D101.
D101 is a sum of D60 to D100 cells in the column, which needs to be shown
in D30.

As I know I can click on D30 and print =D101, OK

Why did she put =+D101

Does it mean anything or it's just a mistake

 

[Max]

The "+" is extraneous. Harmless, but not necessary.
Believe it's just a legacy habit by ex-Lotus users.

 

[Spiky]

The "+" is extraneous. Harmless, but not necessary.
Believe it's just a legacy habit by ex-Lotus users.

Actually, it's a Windows thing. This doesn't (or at least didn't,
haven't used every Mac version) occur on a Mac, strangely enough.

You can start typing a formula or function with an =, +, or -. It
automatically adds the necessary = at the beginning if you start
typing with a + or -.

If you type a + to start typing in a formula, Win Excel leaves the
plus in there for no apparent reason. Interestingly, if you type a +
followed by numerals, like, "+100+A4", then it does work properly and
the final result is "=100+A4". But if you follow with a reference or a
function, it leaves the extraneous +. So entering "+A4+100" becomes "=
+A4+100".

I think many people use the + because it is on the 10-key portion of
the keyboard, easier to reach than =.

Sometimes I don't care since it is harmless. Sometimes it annoys me
and I do a Replace "=+" with "=".