Unary + Operator

[xcelion]

Hi ,

Can anyone tell me what is the use of unary operator + in formulas(like
=+B4) .What does it mean? .


Thanks in advance
Xcelion

 

[Ron Rosenfeld]

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

 

[Jerry W. Lewis]

It means that the person who wrote it used to use Lotus, and has not
become that proficient in Excel.

Jerry

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[Ken Wright]

LOL

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk