what exactly are relational operators in Excel? All math symbol?

J

JC

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."
 
B

Biff

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
 
J

JC

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

Aladin Akyurek

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

Dana DeLouis

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!!
 
Top