Excel Formula Breakdown Function - This is the desired result. For example, SUM is the function used when you want to add values together.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

You can use the SUM function to quickly calculate totals for columns or rows of data. In a budget spreadsheet, you can use =SUM (B2:B10) to sum expenses over a specific period.

What Is an Example of a Formula in Excel?. Not only does Excel keep information organized in spreadsheets, it can also save you from manually typing data for each cell separately.