plus sign before cell reference in formula

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?
 
B

Bernard Liengme

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

Top