Excel Logical Tests

Use:
Evaluates any T/F comparison
Syntax:
cell or formula   logical operator   cell or formula
Logical Operators:
=         <>         <         <=         >         >=
Examples:
D12 > 500
D12 > 500 + MAX( A17:F17 )
500 < D12
MAX( A17:F17 ) >= MEDIAN( A17:F17 )
F12 = "John Mote"
F12 <> "John Mote"
"Mote, John" < "Williams, Ted"
Related Functions:
IF, AND, OR
Lotus 123 and Quattro Equivalent:
=         <>         <         <=         >         >=
button Home | Lectures | Handouts | Assignments | Exams | Grades | Odds & Ends
button This website is maintained by John Mote for use by students in his MIS 311F class. Your comments and questions are welcomed.