Some of the operators in Libre Office Cal care: Arithmetic, Relational and Logical.

**Operators in Libre
Office Calc**

**Operators
in Libre Office Calc**

Some of the operators in Libre
Office Cal care: Arithmetic, Relational and Logical.

__1. Arithmetic Operators__

Arithmetic operators are used to do
some kind of calculations with numeric values. They cannot be used with
strings.

__2. Relational Operators__

Relational operators are used to
compare two values. They form relational expressions. These operators always
give a single value as result: True or False

__3. Logical Operators__

Logical Operators are used to
compare two or more relational expressions. These operators also always give a
single value as result True or False.

Operator: NOT, AND, OR

**Example**

Akshay’s mother has purchased some
fruits from the market. Make a list of fruits and find how much each fruit
costs her.

1. Make the initial worksheet

2. Type the formula = C3* D3in Cell
E3.

3. Similarly, type all the formulae
in the other cells as given

4. To calculate the grand total,
Type the formula = E3 + E4+E5 +E6 in Cell E7 and press the enter key to get the
result. Or Type the formula =sum (E3:E6) in Cell E7 and press the enter key to
get the result.

5. Save the file with the name
‘Market’.

Tags : Libre Office Calc | Chapter 23 | 8th Science , 8th Science : Chapter 23 : Libre Office Calc

Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail

8th Science : Chapter 23 : Libre Office Calc : Operators in Libre Office Calc | Libre Office Calc | Chapter 23 | 8th Science

**Related Topics **

Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.