formula starts : =+ what does plus indicate?

[pskwaak]

Found a formula that uses a plus (=+) at the start when referencing a cell
result in another worksheet within the workbook. Why the plus?

[RagDyer]

Probably because the creator of the formula had a habit established when
they were using 123 (Lotus).

The + in 123 is the equivalent of the = sign in XL, it designates the start
of a formula.

Completely unnecessary in XL and can be eliminated.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pskwaak" <pskwaak@discussions.microsoft.com> wrote in message
news:6B34BB86-9888-4F0D-8FAC-46F2E9DF0A50@microsoft.com...
> Found a formula that uses a plus (=+) at the start when referencing a cell
> result in another worksheet within the workbook. Why the plus?

[Fred Smith]

It's superfluous. Some people start formulas with =, some with + (a throwback to
Lotus 1-2-3 days). You don't need both, and can safely delete (or ignore) one.

--
Regards,
Fred


"pskwaak" <pskwaak@discussions.microsoft.com> wrote in message
news:6B34BB86-9888-4F0D-8FAC-46F2E9DF0A50@microsoft.com...
> Found a formula that uses a plus (=+) at the start when referencing a cell
> result in another worksheet within the workbook. Why the plus?

[Ron Rosenfeld]

On Thu, 23 Feb 2006 18:29:27 -0800, "pskwaak"
<pskwaak@discussions.microsoft.com> wrote:

>Found a formula that uses a plus (=+) at the start when referencing a cell
>result in another worksheet within the workbook. Why the plus?

Programmer habit from using a different tool.
--ron