Excel Formulas List PDF with Examples in Excel Sheet

Check out excel formulas list with examples, download advanced most popular excel formulas pdf list, how to use formulas in Excel sheet

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], …)
List of Excel Formulas

Excel Formulas List

  1. SUM
  2. COUNT
  6. MIN Excel
  7. MAX Excel
  8. LEN Excel
  9. TRIM Excel
  10. 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