The use of A + when referring to a cell

  • Thread starter Thread starter sjenks183
  • Start date Start date
S

sjenks183

I was browsing an excel spreadsheet created by someone else and it wa
using the IF statement along with nested formulas. The formul
actually looks like:

=IF(+B14<=$D$5,+$F$4-D14,0)

My question is what does the + represent before cell B14.

Thanks
 
I think it's a hangover from Lotus 123 users.

In excel, you usually start a formula with =. In 123, it was +.

Excel is usually very forgiving, but I think it's a waste of typing and makes
things more difficult to read.

+B14 is the same as B14 in this case.
 
Back
Top