Formulas & Functions
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 finds the sum of the range of values from cell A1 to cell A3.
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.
The basic syntax for a function is an equals sign (=), the function name (SUM, for example), and one or more arguments.
Arguments:
Multiple arguments must be separated by a comma.
Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.
Enter a formula that contains a built-in function
Detailed formula examples for key functions, including VLookup, Index, Match, Rank, Sumproduct, Average, Small, Large, Lookup, Round, Countifs, Sumifs, Choose, Find, Search, Date, and many more
you will find a searchable list of 200 Excel Functions. Next to each function, you'll see a description of the function along with the function's syntax.
Excel functions (alphabetical)
Microsoft office help with formulas and functions
Information on Functions and formulas from Microsoft
This article introduces the basic concepts you need to know to be proficient with formulas in Excel
Excel Formulas & Functions: Learn with Basic Examples
Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions.
Basic Excel formulas & functions with examples
The tutorial provides a list of Excel basic formulas and functions with examples and links to related in-depth tutorials.
guide to formulas and functions from ITconnect