Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Plus sign in front of a formula
Hi, I have a simple question here, I am looking at a spreasheet and there is a plus sign in front of all the sum formulas, ex: =+SUM(E28;E30), what does it mean? Thanks for the help. Marcos -- marksuza ------------------------------------------------------------------------ marksuza's Profile: http://www.excelforum.com/member.php...fo&userid=2659 View this thread: http://www.excelforum.com/showthread...hreadid=477896 |
#2
|
|||
|
|||
Plus sign in front of a formula
I'm still used to starting formulas off with a plus sign to indicate I want the cell to be a formula. I think this was one way you could do it 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, excel automatically puts the = in. Thus you can end up with formulas beginning =+. Not sure but I think this is why. -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=477896 |
#3
|
|||
|
|||
Plus sign in front of a formula
Thanks Timmy. Marcos -- marksuza ------------------------------------------------------------------------ marksuza's Profile: http://www.excelforum.com/member.php...fo&userid=2659 View this thread: http://www.excelforum.com/showthread...hreadid=477896 |
#4
|
|||
|
|||
Plus sign in front of a formula
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" wrote in message ... I'm still used to starting formulas off with a plus sign to indicate I want the cell to be a formula. I think this was one way you could do it 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, excel automatically puts the = in. Thus you can end up with formulas beginning =+. Not sure but I think this is why. -- Timmy Mac1 ------------------------------------------------------------------------ Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188 View this thread: http://www.excelforum.com/showthread...hreadid=477896 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the sign to keep the number the same in the formula | Excel Discussion (Misc queries) | |||
Need to use the + sign but not in a formula | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Formula for adding a comma in front of text in a cell | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |