Significance of =+ in formulas

Good thinking Bob, I bet it was something like that. I'll consider the
mystery solved!



"Bob Phillips" wrote in message
...
Dave,

It's probably the same thing. The + will coerce a text string into
numeric,
so for instance if you enter '1 in A1 and '2 in A2, and do +SUM(A1:A2),
you
get 0. But do =+A1+A2, and you get 3, as the + is coercing the text
strings
to numeric.

Your +" "& could well be the same sort of thing.

And I don't see it would be any different in 2003 from 2000.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dave R." wrote in message
...
No, it wasn't that.

I didn't explain very well, partially because I don't remember very
well,
but I think it was some formula that began like

+" "&


where starting the formula with a + returned different (text) result
than
when I used =. Althou now, this example is not returning anything weird,
I'm
just going on fuzzy memory.

Again I don't remember. I wish I had written it down or brought it up
for
pondering here. Now I'm using XL 2003 instead of 2000, so I don't know
if
it
would behave the same, I'll monkey with it again one day I'm sure.




"Bob Phillips" wrote in message
...
probably where the cell is formatted as text.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dave R." wrote in message
...
How lovely to see other people using that. No, it wont affect the
formula
other than beautifying it a bit. It is likely from a person who cut
his
teeth using Lotus 123, where formulas are started with a +.

I was monkeying around with it a few months ago, and did discover a
time
when it reacted differently than using = .. I think it might have
been
when
using quotes or something, but I really should have written it down
because
now I can't remember!



"tro34" wrote in message
om...
Is there any significance to the =+ in the following formula?

=+G70/(1-$E$76)

I'm updating a fairly complex spreadsheet and I keep running into
this. As far as I can tell it behaves the same as = by itself.

"Bob Phillips" wrote...
It's probably the same thing. The + will coerce a text string into numeric,
so for instance if you enter '1 in A1 and '2 in A2, and do +SUM(A1:A2), you
get 0. But do =+A1+A2, and you get 3, as the + is coercing the text strings
to numeric.

It's the second + in =+A1+A2 that triggers the conversion. The leading + is
superfluous.

Your +" "& could well be the same sort of thing.
...

Unlikely. Leading =+ and = are interchangeable.

--
To top-post is human, to bottom-post and snip is sublime.

Bob-

A "unary +" doesn't coerce anything. + is a binary operator only in XL,
completely ignored if there's no lArg, which is why it's unnecessary
after the = sign. So only the second + does any coercing in your example.

Try:

A1: =+"1"
B1: =ISTEXT(A1) ===== TRUE


A2: =-"1"
B2: =ISTEXT(A2) ===== FALSE

Of course, if you use the "unary +" anywhere other than after the =
sign, XL gets rid of it for you...


In article ,
"Bob Phillips" wrote:

It's probably the same thing. The + will coerce a text string into numeric,
so for instance if you enter '1 in A1 and '2 in A2, and do +SUM(A1:A2), you
get 0. But do =+A1+A2, and you get 3, as the + is coercing the text strings
to numeric.

Your +" "& could well be the same sort of thing.

And I don't see it would be any different in 2003 from 2000.

In article ,
"Harald Staff" wrote:

It's quite common to do this, since entering the = is a two-hand operation
and there isn't any on the numeric keypad.

Hmm... there is on mine:

clr = / *

7 8 9 -

4 5 6 +

1 2 3 ^
Enter
0 . V

What a mess!

Regards


"JE McGimpsey" a écrit dans le message de news:
...
Bob-

A "unary +" doesn't coerce anything. + is a binary operator only in XL,
completely ignored if there's no lArg, which is why it's unnecessary
after the = sign. So only the second + does any coercing in your example.

Try:

A1: =+"1"
B1: =ISTEXT(A1) ===== TRUE


A2: =-"1"
B2: =ISTEXT(A2) ===== FALSE

Of course, if you use the "unary +" anywhere other than after the =
sign, XL gets rid of it for you...


In article ,
"Bob Phillips" wrote:

It's probably the same thing. The + will coerce a text string into
numeric,
so for instance if you enter '1 in A1 and '2 in A2, and do +SUM(A1:A2),
you
get 0. But do =+A1+A2, and you get 3, as the + is coercing the text
strings
to numeric.

Your +" "& could well be the same sort of thing.

And I don't see it would be any different in 2003 from 2000.

Ok, final straw, I'll buy your Mac then bg
This has to do with languages and regions then. This is a scandinavian Pc
keyboard:
= is entered by Shift 0
Numeric keypad (comma meaning default decimal separator):

Numlock / * -

7 8 9 ^
+
4 5 6 v

1 2 3 ^
Enter
0 , V

What does your german keyboard layout look like, Frank ?

Best wishes Harald

"JE McGimpsey" skrev i melding
...
In article ,
"Harald Staff" wrote:

It's quite common to do this, since entering the = is a two-hand
operation
and there isn't any on the numeric keypad.

Hmm... there is on mine:

clr = / *

7 8 9 -

4 5 6 +

1 2 3 ^
Enter
0 . V

Doesn't anyone, besides me, have an equal sign just to the left of the
backspace key, whch also has a plus sign when shifted?
--


Regards,

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

"Frank Kabel" wrote in message
...
Harald Staff wrote:
Ok, final straw, I'll buy your Mac then bg
This has to do with languages and regions then. This is a
scandinavian Pc keyboard:
= is entered by Shift 0
Numeric keypad (comma meaning default decimal separator):

Numlock / * -

7 8 9 ^
+
4 5 6 v

1 2 3 ^
Enter
0 , V

What does your german keyboard layout look like, Frank ?


Hi Harald
also have to enter SHIFT + 0 to get the equation sign. Numeric keypad
also looks the same (though I normaly use my Laptop without this
keypad)

Frank

Yes RagDyer. I am here in America. This is the same button I use to begin my
formulas with +, by holding shift and striking the key you name.


"RagDyer" wrote in message
...
Doesn't anyone, besides me, have an equal sign just to the left of the
backspace key, whch also has a plus sign when shifted?
--


Regards,

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

"Frank Kabel" wrote in message
...
Harald Staff wrote:
Ok, final straw, I'll buy your Mac then bg
This has to do with languages and regions then. This is a
scandinavian Pc keyboard:
= is entered by Shift 0
Numeric keypad (comma meaning default decimal separator):

Numlock / * -

7 8 9 ^
+
4 5 6 v

1 2 3 ^
Enter
0 , V

What does your german keyboard layout look like, Frank ?


Hi Harald
also have to enter SHIFT + 0 to get the equation sign. Numeric keypad
also looks the same (though I normaly use my Laptop without this
keypad)

Frank

RD

That is normal keyboard. OP wanted a one finger = sign.

Gord

On Wed, 24 Mar 2004 13:36:34 -0800, "RagDyer" wrote:

Doesn't anyone, besides me, have an equal sign just to the left of the
backspace key, whch also has a plus sign when shifted?

Hi Gord!

OP wanted a one finger = sign

ROTFLMAO

I misread that first time around!

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.