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.
There are 2 basic ways to perform calculations in excel - formulas and functions.
Formulas - In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which find the sum of the range of values from cell A1 to cell A3.
Functions - Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human friendly names. For example :- =SUM(A1:A3). The function sums all the values from A1 to A3.
MS Excel Formulas List
| SUM Excel Formula : | SUM(number1, [number2] ) |
| AVERAGE Excel Formula : | AVERAGE(number1, [number2], …) |
| MAX & MIN Excel Formula : | =MAX(A2:A5) =MIN(A2:A5) |
| COUNT & COUNTA Formula : | COUNT(value1, [value2], …) |
| IF Excel Formula : | IF(logical_test, [value_if_true], [value_if_false]) |
| TRIM Excel Formula : | = TRIM (A1) |
| LEN Excel Formula : | =LEN (text) |
| CONCATENATE Excel Formula : | CONCATENATE(text1, [text2], …) |
Excel Formulas List
- SUM
- COUNT
- COUNTA
- COUNTBLANK
- AVERAGE
- MIN Excel
- MAX Excel
- LEN Excel
- TRIM Excel
- IF Excel
For Microsoft Software Update visit Microsoft website https://www.microsoft.com/en-in
Excel Formulas List PDF Download
Download Excel formulas list pdf with Examples from below link.
https://www.shastacoe.org/uploaded/Dept/it/training_docs/Excel/Excel_Introduction_to_Formulas.pdf
Read : eSkillindia Courses List 2022-23| Free Online NSDC Certificate Courses
