Working With Formulas in MS Excel 2010
Formulas form an essential part of the worksheet in Excel 2010. It is not possible to imagine a worksheet devoid of support for formula. Formula can be easily defined a special code which are entered into the cell to get required results instantly and efficiently. Formulas happen to perform some calculation which varies from mild to complex and it returns a result in the cell on the basis of its calculations.
Formula makes use of wide variety of operators and worksheet works in synchronized fashion to come up with values and texts. The values and texts used by the formula are stored in the cell which can be changes as per the changing need. MS Excel 2010 allows users to write and edit the formulas as per their needs and it lens a dynamic nature to the worksheet which makes it fun to use Excel 2010.
Elements of Formula
A formula in Excel 2010 can consist of any of these elements such as:
- Mathematical operators like + (for addition purpose) and / (for division)
Example: =A1+A2 (This will add values present in cells numbered A1 and A2)
- Values or text
Example: =100*0.5 (This multiplies 100 times 0.5. It should be noted that this formula only makes use of the values and it will certainly return the same result of 50)
- Cell references (including named cells and ranges)
Example: =A1=B12 (This formula will compare the cell A1 with B12. If both the cells are identical then this formula will return TRUE Otherwise False)
- Worksheet functions
Example: =SUM(A:1A12) (This formula will add the values in the range of A1 to A12 cells.