"+=" or "="

[jkupov]

Okay, this may be a stupid question...

I generally start my excel functions with an equal sign (=) but a coworker starts a lot of hers with and equal sign and a plus sign (=+). What's the difference?

Exammple:

=sum(G2:G35711)

or

=+sum(G2:G35711)

 

[SkipVought]

hi,

No need for anything but the EQUAL sign.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

This is before my time, but I think "=+" is a holdout from the days of Lotus 123.

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[jkupov]

Thanks!

 

[Blorf]

I still use += because I am an old fart who started out with symphony back in the day.

I don't even put the =, just the +, excel adds the = for me.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[flubbard]

For reference, in excel simply starting with + will also work (I find this more useful since + is on the number pad but = is not). I know this works at least in the windows version of office, but does not work in other programs like OpenOffice.org

Hope this helps.

- flub