In: Computer Science
What is a formula? Explain with the help of an example.
Formulas are used to perform calculation in volving addition, subtraction, divison, and multiplication etc. A formula establishes a relationship between two or more cells. It is an expression that can include cell addresses, numbers, arithemetic operation, and parenthessis.
A formula must begin with an equalto(=) symbol followed by cell refernces and operators. It may contain a few or all of the below mentioned elements :-
1. References
2. Operators
3. Constants
4. Function
For example =B2+C2+D2
Formulas are used to perform calculations in volving addition, subtraction, divison and multiplication.