|
Why do we start the formula with + or -
Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
I think it is strictly a "carry-over" from individuals "Lotus-Days".
Excel didn't embrace the feature/requirement. HTH "Jim333" wrote in message ... Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
Homework?
"Jim333" wrote in message ... Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
hope i'm not raining on someones homework. it is a carryover from lotus 123.
if you enter +sum(A1:A5), excel automatically throws in the = sign, but leaves the + sign. "Don Guillett" wrote: WE don't. Only 123 users do it. Happy homework -- Don Guillett SalesAid Software "Jim333" wrote in message ... Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
When we switched from Lotus 123 to Excel, there were a lot of 123 users who
couldn't break that habit. (I find it irritating, too <vbg.) Another one that lots of lotus users did (ok a few, ok just one!) was: =sum(a1+b1) or even worse: =+sum(a1+b1) Jim333 wrote: Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 -- Dave Peterson |
Thank you soooooo much for all -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
No, more than "just one", I'm sure.
On Sat, 04 Jun 2005 16:48:45 -0500, Dave Peterson wrote: When we switched from Lotus 123 to Excel, there were a lot of 123 users who couldn't break that habit. (I find it irritating, too <vbg.) Another one that lots of lotus users did (ok a few, ok just one!) was: =sum(a1+b1) or even worse: =+sum(a1+b1) Jim333 wrote: Hi everybody, I have noticed that some people start the formula with + or - after equal sign e.g. =+if(... My question is: what is the main purpose of doing that I need a detaild answer with some examples if available. Thank you,, -- Jim333 ------------------------------------------------------------------------ Jim333's Profile: http://www.excelforum.com/member.php...fo&userid=5186 View this thread: http://www.excelforum.com/showthread...hreadid=376504 |
| All times are GMT +1. The time now is 10:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com