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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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."