View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default plus sign before cell reference in formula

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"KrispyData" wrote in message
...
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?