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 |
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 |
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? . |
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 |
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 |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com