plus sign before cell reference in formula

  • Thread starter Thread starter KrispyData
  • Start date Start date
K

KrispyData

what is the difference between this formula:

=+C31*$D$14

and this one:

=C31*$D$14

both formula give the same results. what is the purpose of the plus sign?
 
The plus sign serves no useful purpose whatsoever
It does tell us that maybe the originator of the workbook began life as a
Lotus 123 users where formulas began with +. And that they have not yet
found that Excel does not require them (old habits die hard - or not at all)
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does a plus sign in front of a cell reference mean? 1
Sum a license total, then vlookup to determine training cost 11
Total time vs hours per shift 1
IF statement on a range of cells in Excel 2007 4
formula help 10
formula 1
Minimum results 4
Conditional formatting, Excel 2007 2

Back
Top