Page 265 - Computer - 9(A&B)

Formulas
A formula in Calc is an expression made up of data values or the cell references of the cells containing data
values along with the mathematical operations. These operators are used along with the operands that can be
the constants or cell references of the values to be used for calculation. Every formula in Calc begins with “=”
sign. The various arithmetical operators that are used in the formulas are:

+ Addition operator
Mathematical Operators – Subtraction operator

* Multiplication operator
= A1 + B1 – C1 / Division operator
^ Exponentiation operator

Equal to Symbol Operands (Cell Addresses) % Percentage operator
Creating Formulas using Fixed Values
We can use the numbers directly in the formula as fi xed values. For example, if you want to add two numbers
say 100 and 200.
Step 1: Select the cell where result is to be displayed and click in it.

Step 2: Enter the formula = 100 + 200 and press the Enter key. The result 300 will appear in the selected cell.

As the formula is created using the fi xed values i.e., 100 and 200, any changes made in any part of the worksheet
will not affect the result at all.

127
127