Calc Guide

characteristic of the number found in the cell, for example -37. The
example for Exponentiation illustrates how to enter a number that is
being multiplied by itself a certain number of times, for example 2
3
=
2*2*2.
Table 8: Arithmetical operators
Operator Name Example
+ (Plus) Addition =1+1
– (Minus) Subtraction =2–1
– (Minus) Negation –5
* (asterisk) Multiplication =2*2
/ (Slash) Division =10/5
% (Percent) Percent 15%
^ (Caret) Exponentiation 2^3
Comparative operators
Comparative operators are found in formulas that use the IF function
and return either a true or false answer; for example, =IF(B6>G12;
127; 0) which, loosely translated, means if the contents of cell B6 are
greater than the contents of cell G12, then return the number 127,
otherwise return the number 0.
A direct answer of TRUE or FALSE can be obtained by entering a
formula such as =B6>B12. If the numbers found in the referenced
cells are accurately represented, the answer TRUE is returned,
otherwise FALSE is returned.
Table 9: Comparative operators
Operator Name Example
= (equal sign) Equal A1=B1
> (Greater than) Greater than A1>B1
< (Less than) Less than A1<B1
>= (Greater than or equal to) Greater than or equal to A1>=B1
<= (Less than or equal to) Less than or equal to A1<=B1
<> (Inequality) Inequality A1<>B1
Chapter 7 Using Formulas and Functions 183