ExcelFunctions.net

Excel Formulas

Home » Excel-Formulas
Excel Built-In Functions:
For help with a specific Excel function, go to one of the following pages:
See also:

Although many people use the term 'Excel Formulas' to refer to the Excel Built-In Functions, the term 'Excel Formula' actually encompasses a wider range of operations in Excel.

Therefore on this site, when we use the term 'Excel Formulas' (or 'Excel Formulae'), we are generally referring to any combination of Excel Operators and/or Excel Functions. This may be as simple as a basic addition (eg. "=A1+B1"), or it could be a complex combination of Excel Operators and multiple nested Excel Functions.

The following links give examples of how to perform many common tasks using Excel Formulas:


Excel Formulas - Practical Examples

The following links show practical examples in which Excel Formulas are used to produce useful working spreadsheets.

Excel Math Formula Examples

Simple Excel Addition Formula
Simple Excel Subtraction Formula
How to Perform Multiplication in Excel
How to Divide in Excel
Excel Average Formulas
Excel Weighted Average Formula
Calculating Percentages in Excel
Calculating Variance in Excel
Calculating Standard Deviation in Excel
Excel Random Number Generation


Excel Date and Time Formula Examples

Age Calculation in Excel
Calculate a Date Difference in Excel
Calculate Time Difference in Excel
Use Formulas to Convert a Time to a Decimal in Excel


Excel Text Formula Examples

Excel String Concatenation
Use Excel Formulas to Split a String in Excel


Other Miscellaneous Excel Formula Examples

Use Excel Formulas to Create a Variable Chart
Create an Excel Drop-Down List that Varies According to the Contents of a Cell
Use Excel Formulas to Highlight Duplicate Rows


For more examples of Excel formulas, visit the Microsoft Office website.