Plus sign in front of a formula

M

marksuza

Hi,

I have a simple question here, I am looking at a spreasheet and ther
is a plus sign in front of all the sum formulas, ex: =+SUM(E28;E30)
what does it mean? Thanks for the help.

Marco
 
T

Timmy Mac1

I'm still used to starting formulas off with a plus sign to indicate
want the cell to be a formula. I think this was one way you could do i
in old forms of excel. Nowadays all formulas begin with an equals sign
If you begin a formula with anything like a + or a - now, exce
automatically puts the = in. Thus you can end up with formula
beginning =+.

Not sure but I think this is why
 
C

Chip Pearson

It is a holdover from Lotus 123 compatibility. It serves no
purpose in Excel, but is harmless if included.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Timmy Mac1"
in message
news:[email protected]...
 
Top