## MS Excel Formulas List

MS Excel Formula mean is calculated by adding up a group of numbers and then dividing the sum by the count of those numbers.

In Microsoft Excel, the mean can be calculated by using one of the following functions: AVERAGE- returns an average of numbers. A formula is an expression that calculates the value of a cell. Functions are predefined formulas and are already available in 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 building a formula:

- All formulae and functions begin with =
- Use your mouse to select a cell or range of cells to be used in a formula
- The operators for building formulae are: + Add * Multiply, – Subtract / Divide
- BODMAS rules apply to arithmetic (Brackets Over Division, then Multiplication, then Addition, then Subtraction).
- Avoid typing variables (such as tax rates) in formulae; instead, type the variable in a separate cell and refer to that cell in the formula
- To repeat formulae down a column, build the formula in the first cell of the column then uses autofill to copy the formula down the column.
**Functions**follow the format =**name(arguments)**where: name the name of the function (e.g. SUM, VLOOKUP)

arguments the cell or range references containing the values used in the function- Where a function contains more than one argument, each argument must be separated by a, (comma).
- Text criteria in an argument must be surrounded by “(quotation marks)

**Download the MS Excel Formulas and Functions List in PDF format using the link given below.**

**Also check – MS Excel Shortcut Keys PDF**

Thanks to your cooperation

Please send me excel sheet formula pdf

very interested this course so i have full kowledge

Hi

Helpful

Please muje exele formula shit send karo

excel formulas sheet send m

sir i want formula of calculate addition,percentage,max,mini send formula sheet

Download the PDF using the download link