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)|
|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
- 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.
Read : eSkillindia Courses List 2022-23| Free Online NSDC Certificate Courses