Excel Built-In Functions:
For help with a specific Excel function,
go to one of the following pages:
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:
The following links show practical examples in which Excel Formulas are used to produce useful working spreadsheets.
|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|
|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|
|How to Convert Seconds to Time in Excel|
|Excel String Concatenation|
|Use Excel Formulas to Split a String in Excel|
|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.