OzGrid

Excel useful formulae reference sheet

< Back to Search results

 Category: [Excel]  Demo Available 

Useful formulae reference sheet

 

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:

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.

 


Gallery



stars (0 Reviews)