This page provides examples of how to use Excel Formulas to perform many common tasks.
Although many people use the term 'Excel Formulas' to refer to the Excel Built-In Functions, the term 'Excel Formula' can encompass 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.
|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|
|Find Duplicates in Excel|
|Remove Duplicates in Excel|
|Find Duplicate Rows in Excel|
|Remove Duplicate Rows in Excel|
Further examples of Excel formulas are provided on the Microsoft Office website.