Excel arithmetic operations

Instead of entering a number in a cell, you can enter an equation (called a formula in Microsoft Excel) that will calculate and display a result. Usually formulas refer to the contents of other cells by using cell references, such as A2, a reference to a cell, or B5 B12, a reference to a range of cells. The value displayed in a cell containing a formula will be automatically updated if values elsewhere in the worksheet are changed. Formulas can contain values, arithmetic operators and other operators, cell references, the wide range of Excel s worksheet functions, and parentheses. 

Emphasis in Chapter 3 is placed on elementary methods, mostly used in arithmetic operations. Basic applications with many examples are presented, using MATLAB and Excel. We may call this is the fundamental part in numerical analysis. 

The Group Theory Calculator [the GT Calculator] is the set of interactive EXCEL spreadsheet files, one for each of the main molecular point groups, on the CDROM supplied with this manual. The group theoretical calculations, which can be performed with the calculator, are rendered possible because of the enhancement of the basic spreadsheet operations and displays using Visual Basic for Applications code and the complex-arithmetic routines available in the Analysis Tool Pack EXCEL Add-ins . Since the Analysis Tool Pack is not one of the standard components loaded in a typical installation of the EXCEL software package, it is necessary, before attempting to use the GT Calculator, to ensure that your version of the EXCEL programme includes this extra component. With any spreadsheet open, check the Add-ins list in the TOOLS menu on the main EXCEL toolbar and, if necessary, install this component in the usual way. 

---