What Are Some Excel Spreedsheet Formulas?

What Are Some Excel Spreedsheet Formulas?

Some simple Excel spreadsheet formulas include =SUM(c1+c2) for addition, =SUM(c1-c2) for subtraction, =SUM(c1*c2) for multiplication and =SUM(c1/c2) for division. The =AVERAGE(c1:c2) formula can provide the average value of a group of cells.

Excel is designed to make it easy to do calculations with large groups of numbers. Accordingly, its formulas are very flexible and also easy to write. For instance, if you want to add a series of numbers that are not in the same column, choose an empty cell for the answer, and type =SUM( in the Formula Bar. Then click a cell, type a comma, and click the next cell until all labels appear in the bar separated by commas. Close the parentheses, and press Enter. The formula adds the values and renders a result. Formulas for subtraction work in the same way.

While the formula =SUM(c1*c2) does simple multiplication, formulas built on PRODUCT are more convenient for multiplying ranges of numbers. To multiply five numbers in cells C1 through C5, for example, type =PRODUCT(c1, c2, c3, c4, c5) or =PRODUCT(c1:c5) in the Formula Bar, and press Enter.

To perform division, use either =SUM(c1/c2) or =QUOTIENT(c1,c2) where c1 is a numerator and c2 is a denominator.

Excel also makes it convenient to calculate averages. For instance, the formula =SUM(c1:c25)/25 averages a range of 25 numbers in cells C1 through C25. An even simpler formula is =AVERAGE(c1:25).