The most important functions include:
=SUM() |
Adds a series of cells together. |
=AVERAGE() |
Calculates the average of a series of cells. |
=IF() |
checks if a condition is met and returns a value if YES and a value if NO |
=MIN() |
Provides the minimum value in a series. |
=MAX() |
Provides the maximum value in a series. |
=LARGE() |
Returns the k-th largest value in a series.
|
=SMALL() |
returns the k-th smallest value in a series |
=COUNT() |
counts the number of cells in a range that contain numbers |
=VLOOKUP() |
looks for a value in the leftmost column of a table and returns in the same row from a column you specify |
See also:
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.