|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 8th, 2005, 11:54 AM
|
|||
|
|||
Unary + Operator
Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=474454 
|
|
#2
October 8th, 2005, 12:33 PM
|
|||
|
|||
|
On Sat, 8 Oct 2005 05:54:54 -0500, xcelion
wrote: Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . It is completely unnecessary in Microsoft Excel in that formula. You would have to ask the particular user for his reason. --ron
|
|
#3
October 8th, 2005, 02:31 PM
|
|||
|
|||
|
It means that the person who wrote it used to use Lotus, and has not
become that proficient in Excel. Jerry xcelion wrote: Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? .
|
|
#4
October 8th, 2005, 07:08 PM
|
|||
|
|||
|
As Jerry said, they are a hang over from someone's Lotus days. If they bug
you (and they do me), you can probably do a find and replace on your sheet, replacing =+ with = -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "xcelion" wrote in message ... Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=474454
|
|
#6
October 9th, 2005, 10:58 AM
|
|||
|
|||
|
LOL :-)
"Sandy Mann" wrote in message ... We had a secretary at work who habitually started formulas with a '+' and she had never even heard of Lotus! When asked why she did it she said. it "just seenmed right" -- HTH Sandy Replace@mailinator with @tiscali.co.uk "Ken Wright" wrote in message ... As Jerry said, they are a hang over from someone's Lotus days. If they bug you (and they do me), you can probably do a find and replace on your sheet, replacing =+ with = -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "xcelion" wrote in message ... Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . Thanks in advance Xcelion -- xcelion ------------------------------------------------------------------------ xcelion's Profile: http://www.excelforum.com/member.php...o&userid=16287 View this thread: http://www.excelforum.com/showthread...hreadid=474454
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Complex Grouping (I think) and totalling | Rose | Running & Setting Up Queries | 4 | December 13th, 2004 01:00 AM |
| How to make the Operator a Variable? | CaptainMyCaptain | Running & Setting Up Queries | 1 | October 20th, 2004 03:05 PM |
| Missing Operator Problem | Benjamin | Running & Setting Up Queries | 4 | August 26th, 2004 01:34 PM |
| Graph against Operator Characters (ACCESS 2K) | [email protected] | Setting Up & Running Reports | 1 | July 22nd, 2004 04:48 PM |
| me operator | Marc | Worksheet Functions | 4 | March 18th, 2004 12:27 PM |
Linear Mode
