MS Excel Formulas List
Understanding MS Excel formulas is essential for anyone wanting to work efficiently with data. MS Excel formulas are used to calculate values, analyze information, and improve your spreadsheet skills.
What is MS Excel Formula?
In Microsoft Excel, the mean is calculated by adding up a group of numbers and then dividing the total by how many numbers there are. To compute the mean, you can use the AVERAGE function. A formula is a mathematical expression that determines the value of a cell while functions are predefined formulas built into Excel.
Excel Formulas List
- SUM
- COUNT
- COUNTA
- COUNTBLANK
- AVERAGE
- MIN Excel
- MAX Excel
- LEN Excel
- TRIM Excel
- IF Excel
MS Excel Formula & Functions Basics
When creating a formula, please remember the following:
- All formulas and functions start with =
- Use your mouse to select a cell or range of cells for your formula
- The symbols for creating formulas include: + for Add, * for Multiply, – for Subtract, and / for Divide
- Follow BODMAS rules for arithmetic (Brackets, Orders, Division, Multiplication, Addition, Subtraction).
- Instead of typing variables like tax rates directly in formulas, place them in a separate cell and refer to that cell.
- To copy formulas down a column, create the formula in the first cell and then use autofill to continue down.
- Functions use the format =name(arguments), where: name refers to the function name (like SUM or VLOOKUP)
arguments are the cell or range references with the values for that function. - If a function needs more than one argument, separate them with a comma (,).
- Wrap text criteria in an argument with “(quotation marks).
Download the MS Excel Formulas and Functions List in PDF format using the link given below.