Topic 2 - Spreadsheets

Study Unit 4 / 5: Exam – Logical Test

WHAT IS THE LOGICAL TEST

A LOGICAL TEST IS ANY VALUE OR EXPRESSION THAT CAN BE EVALUATED AS EITHER TRUE OR FALSE.

A logical test usually consists of three parts:

1. A cell reference

2. A comparison calculation operator, that is…

less than (<) greater than or equal to (>=)
less than or equal to (<=)
not equal to (<>)
equal to(=)

3. A value, text, cell reference or formula

WHAT IS THE COMPARISON OPERATOR

Two values compared by using these, the result is true or false

Written Out..

= (EQUAL SIGN) A1=B1

> (GREATER THAN SIGN) A1>B1

< (LESS THAN SIGN) A1= (GREATER THAN OR EQUAL TO SIGN) A1>=B1

<= (LESS THAN OR EQUAL TO SIGN) A1<=B1

<> (NOT EQUAL TO SIGN) A1<>B1

Study Unit 4 / 5: Exam – Referencing Cells (Prev Lesson)
(Next Lesson) Study Unit 4 / 5: Exam – TEXT
Back to Topic 2 – Spreadsheets

No Comments

Comments are closed.