Excel useful formulae reference sheet

< Back to Search results

 Category: [Excel]  Demo Available 

Useful formulae reference sheet


The most important functions include:


Adds a series of cells together.


Calculates the average of a series of cells.


checks if a condition is met and returns a value if YES and a value if NO


Provides the minimum value in a series.


Provides the maximum value in a series.


Returns the k-th largest value in a series.



returns the k-th smallest value in a series


counts the number of cells in a range that contain numbers


looks for a value in the leftmost column of a table and returns in the same row from a column you specify


See also:

Dates and time Excel formulas reference sheet
Conditional Functions Reference Sheet
Excel different types of data reference sheet
Useful formulae reference sheet
Financial formulae reference sheet
Index and match reference sheet
Lookup formulae reference sheet
Maths functions excel formulae sheet


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.



stars (0 Reviews)