Page 24 - Viva ICSE Computer Studies 8 : E-book

Logical Operators

The logical operators are used to compare two or more relational expressions. They also give
result in true or false.

Logical Operators
AND OR NOT

Working with a Basic Formula Learn More

A basic formula uses only
one type of operator.

Follow these steps to use a basic
formula.

1. Enter data as shown in the
Step 1
screenshot.

2. Click on the cell B7, where the result
will be displayed and type = sign.
3. Click on the cell B1. A dashed border
will appear around it.
Step 3
4. The address of cell B1 will appear
in ‘cell B7’ and also in the ‘Formulas’ Step 5
bar.

5. Type + symbol in ‘cell B7’. Step 6
6. Repeat the steps till B6 or you can
Step 2
type = B1 + B2 + B3 + B4 + B5 + B6
in ‘cell B7’. Step 4

7. Press the Enter key. Cell B7
will display the sum of all the
values.

Step 7

12