| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify formula | Excel Worksheet Functions | |||
| what should i use | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Linear Mode
