top of page

Spreadsheet Formulas

Microsoft Excel’s power lies in its ability to organize related data and to display results of calculations; thus, enabling interpretation of quantitative data for decision making.

A formula is a mathematical expression that calculates the value of a cell.

 

Excel calculates data using formulas.

An example of an Excel formula is shown below.

 

Formula

Other examples of formulas include:

= AVE(C7 * B5)

= MIN (G2:G6)

 

.

bottom of page