Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JC
 
Posts: n/a
Default 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."
  #2   Report Post  
Biff
 
Posts: n/a
Default

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



  #3   Report Post  
JC
 
Posts: n/a
Default

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

  #4   Report Post  
JC
 
Posts: n/a
Default

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

  #5   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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



  #6   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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

  #7   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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



  #8   Report Post  
JC
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Stop Excel Rounding Dates leinad512 Excel Discussion (Misc queries) 1 April 20th 05 04:19 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Excel error - Startup (and Acrobat PDFMaker) gxdata Setting up and Configuration of Excel 0 February 4th 05 03:44 AM
Excel 2002 and 2000 co-install. Control Which Starts ? cnuk Excel Discussion (Misc queries) 2 January 17th 05 08:07 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"