What is operator in Excel Office 2010 formula ?

Microsoft Office 2010 professional
February 1, 2012 at 02:43:40
Specs: Windows Xp
What is operator "<space>" in Excel Office 2010 formula ?
Pay attention, operator < >, and not <> without space ?

See More: What is operator in Excel Office 2010 formula ?

Report •

#1
February 1, 2012 at 07:17:30
Please provide the formula in which this "operator" is used.

I can find no reference on any Microsoft site that mentions an operator consisting of the Less Than-Space-Greater Than symbols.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 1, 2012 at 07:36:46
Sounds like a homework question.....

From the Excel Help:

The <space> character:

Intersection operator, which produces on reference to cells common to the two references (B7:D7 C6:C8)

MIKE

http://www.skeptic.com/


Report •

#3
February 1, 2012 at 07:57:01
I don't believe that the OP is asking about the space operator.

I believe he is asking about < > with the brackets being part of the operator.

Weren't you "paying attention"? ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
February 1, 2012 at 09:03:22
Without further clarification from the OP,
I read it that they are showing the <space> character,
they then are showing the actual space character < >
as opposed to the not equal <> operator.

MIKE

http://www.skeptic.com/


Report •

#5
February 1, 2012 at 09:23:27
I agree that we need to hear from the OP.

There's 2 items that have me thinking that he means a 3-character operator:

In the first line he put the brackets and the word space inside the quotes: "<space>"

I take that to mean that everything inside the quotes is the operator in question.

In the second line he says:

"Pay attention, operator < >, and not <> without space ?"

When he say's not <> without space I take it to mean that he is asking about the backets with the space in between them.

Of course, I don't really care for his use of the words "Pay attention" but we'll let that go for now.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
February 2, 2012 at 00:07:56
Ok people, i have found out that the Office 2010 Excel help for the operators isn't well done (cf: http://office.microsoft.com/en-us/e... under-title: Operator precedence). The operator "<space>",written"< >", doesn't exist. They put that operator to explain: operator "<" and operator ">". So the right way to write: A1(cell value) Not equal to B1(cell value) is: A1<>B1 (without spaces)

Report •

#7
February 2, 2012 at 01:28:05

Report •

Ask Question