Q:

# What are some Excel spreedsheet formulas?

A:

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.

## Keep Learning

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).

Sources:

## Related Questions

• A: Microsoft's support page for its Excel spreadsheet application offers free training courses, videos and tutorials for beginners. As of 2015, tutorials for ... Full Answer >
Filed Under:
• A: To insert a check box in an Excel spreadsheet, enable the Developer tab from Settings. Once the tab is visible, use it to drag and drop a check box.... Full Answer >
Filed Under:
• A: The AutoSum feature in Excel provides a shortcut to adding up columns or rows of numbers in an Excel spreadsheet. It can add up to 255 numbers at one time.... Full Answer >
Filed Under:
• A: SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parame... Full Answer >
Filed Under:
PEOPLE SEARCH FOR