View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Why put a plus sign after = sign in a formula

Hi,

The plus sign serves no function at all, in fact it is a waste. This
usually appears because the Excel user formally was a Lotus 1-2-3 user and
in that program you started most formulas with +. If you start the formulas
with + in Excel, Excel converts this to =+.

Here are some examples of other bad practices:

=SUM(A1+A3) should be =A1+A3
=SUM(A1-A3) should be =A1-A3
=+SUM(A1:A4) should be =SUM(A1:A4)

Cheers,
Shane Devenshire

"kMan" wrote in message
...
Very basic question guys and gals,

I have a formula like this in, say, Cell A2:
=+A1

What does the "+" sign do? I think I asked this question in a workshop
ages
ago, but forgot the answer I got :(

Thanks for ya 'elp....