The formulas are what make a spreadsheet a spreadsheet. Excel allows you to introduce flexible used
values (or text) in cells to calculate the result. When you enter a formula
in a cell, the result of the formula appears in the cell. If you change any of the cells used by a formula, the formula recalculates and
displays the new result.
Formulas can be simple mathematical expressions, or can use some
powerful functions that
are built into Excel. In Picture shows an Excel spreadsheet set up to
calculate the monthly loan payment. The worksheet contains the values, text and formulas. The cells in
column B contain text.
Column C contains four values and two formulas. The formulas are in cells C7
and 11. Column E, as a reference, shows the actual content of the cells in
column C.
 |
| raj-excel.blogspot.com |
No comments:
Post a Comment