[SOLVED] what exactly are relational operators in Excel? All math symbol?

I am taking a test this week and one of the questions (which has been
supplied by the instructor) is a multiple choice with answers which do not
seem to be correct. Are Valid relational operators: + * / + or -,
or should they be: "equal to, not equal to, less than, etc. as indicated in
my text book."

Hi!

I am by no means an expert on these matters but in some formula constructs
plus (+) can mean the relational expression OR and multiply (*) can mean the
relational expression AND.

Biff

"JC" <[email protected]> wrote in message
news:[email protected]...
>I am taking a test this week and one of the questions (which has been
> supplied by the instructor) is a multiple choice with answers which do not
> seem to be correct. Are Valid relational operators: + * / + or -,
> or should they be: "equal to, not equal to, less than, etc. as indicated
> in
> my text book."

Thanks a lot! I am going back to college after 40 years, and hope to get 4.0


"JC" wrote:

> I am taking a test this week and one of the questions (which has been
> supplied by the instructor) is a multiple choice with answers which do not
> seem to be correct. Are Valid relational operators: + * / + or -,
> or should they be: "equal to, not equal to, less than, etc. as indicated in
> my text book."

Biff, what about "all numeric expressions." which is one of the
possibilities listed. Thanks if you have time.


"JC" wrote:

> I am taking a test this week and one of the questions (which has been
> supplied by the instructor) is a multiple choice with answers which do not
> seem to be correct. Are Valid relational operators: + * / + or -,
> or should they be: "equal to, not equal to, less than, etc. as indicated in
> my text book."

Your textbook is right.

JC wrote:
> I am taking a test this week and one of the questions (which has been
> supplied by the instructor) is a multiple choice with answers which do not
> seem to be correct. Are Valid relational operators: + * / + or -,
> or should they be: "equal to, not equal to, less than, etc. as indicated in
> my text book."

Numeric expressions can be set up using arithmetic operators, relational
operators, and/or functions, so they are thus not "valid relational
operators."

JC wrote:
> Biff, what about "all numeric expressions." which is one of the
> possibilities listed. Thanks if you have time.
>
>
> "JC" wrote:
>
>
>>I am taking a test this week and one of the questions (which has been
>>supplied by the instructor) is a multiple choice with answers which do not
>>seem to be correct. Are Valid relational operators: + * / + or -,
>>or should they be: "equal to, not equal to, less than, etc. as indicated in
>>my text book."

Hi. In Excel Help, do a search for "About calculation operators"

Excel calls them "Comparison Operators". Other terms might be "Relational
operators."
http://www.webopedia.com/TERM/O/operator.html

(In the Math program Mathematica, terms like <, =, >, etc are found under
"Relational Operators" also.)
Good luck on the test!!
--
Dana DeLouis
Win XP & Office 2003


"JC" <[email protected]> wrote in message
news:[email protected]...
>I am taking a test this week and one of the questions (which has been
> supplied by the instructor) is a multiple choice with answers which do not
> seem to be correct. Are Valid relational operators: + * / + or -,
> or should they be: "equal to, not equal to, less than, etc. as indicated
> in
> my text book."

Thanks I will try it.




"Dana DeLouis" wrote:

> Hi. In Excel Help, do a search for "About calculation operators"
>
> Excel calls them "Comparison Operators". Other terms might be "Relational
> operators."
> http://www.webopedia.com/TERM/O/operator.html
>
> (In the Math program Mathematica, terms like <, =, >, etc are found under
> "Relational Operators" also.)
> Good luck on the test!!
> --
> Dana DeLouis
> Win XP & Office 2003
>
>
> "JC" <[email protected]> wrote in message
> news:[email protected]...
> >I am taking a test this week and one of the questions (which has been
> > supplied by the instructor) is a multiple choice with answers which do not
> > seem to be correct. Are Valid relational operators: + * / + or -,
> > or should they be: "equal to, not equal to, less than, etc. as indicated
> > in
> > my text book."
>
>
>