User Manual

Chapter 5 Creating Tables 119
Comparison operators compare two values and return TRUE or FALSE.
/ The result of dividing one
value by another value
A2/B2 returns 10
^ The result of raising one value
to the power another value
A2^B2 returns 400
% The result of dividing a value
by 100
A2% returns 0.2
Notes:
 When a cell reference points to an empty cell, 0 is the value used.
 When a cell reference points to a cell containing FALSE, 0 is used. If the cell
contains TRUE, 1 is used. For example, TRUE + 1 returns 2.
 Using a text string with an arithmetic operator returns an error.
For example, 3 + “hello” is not a correct arithmetic operation.
This operator Returns
Example (A2 contains 20 and
B2 contains 2)
This operator Returns
Example (A2 contains 20 and
B2 contains 2)
= TRUE if two values are equal A2=B2 returns FALSE
<> TRUE if two values aren’t equal A2<>B2 returns TRUE
> TRUE if the first value is
greater than the second value
A2>B2 returns TRUE
< TRUE if the first value is less
than the second value
A2<B2 returns FALSE
>= TRUE if the first value is
greater than or equal to the
second value
A2>=B2 returns TRUE
<= TRUE if the first value is less
than or equal to the second
value
A2<=B2 returns FALSE
Notes:
 Text strings are larger than numbers. For example, “hello” > 5 returns TRUE.
 TRUE and FALSE can be compared with each other, but not with numbers
or text strings. TRUE > FALSE, and FALSE < TRUE.
 To type a Boolean value (TRUE or FALSE), type an equal sign, type the value
in the Formula Editor, and press Return.