Create Presentation
Download Presentation

Download Presentation
## Excel Functions and Formula

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -

**G042 Task 4**Excel Functions and Formula**Session Objectives**• Understand how to use a range of different functions in excel. • Used a range of functions within your excel spreadsheet.**Sum Function**• The syntax for sum function =Sum(first cell:last cell)**Max or Min Function**• The syntax for max function =Max(first cell:last cell) • The syntax for max function =Min(first cell:last cell)**Average (Mean) Function**• The syntax for average function =Average (first value, second value, etc.)**Other Averages**• To work out the median =Median (first value, second value, etc.) • To work out the mode =Mode (first value, second value, etc.)**Count Function**• The syntax for sum function =Count(first cell:last cell) • Blank entries are not counted. • Text entries are NOT counted.**CountA Function**• The syntax for sum function =CountA(first cell:last cell) • Blank entries are not counted. • Text entries are counted.**IF Function**• The syntax is =IF (condition, value-if-true, value-if-false) • value returned may be either a number or text • if value returned is text, it must be in quotes**CountIf Function**• The syntax for sum function =CountIf(first cell:last cell, criteria)**Int Function**• Int returns the nearest integer • The syntax for Int function =Int(number)**LOOKUP Functions**• Returns a value from a list • The syntax for VLOOKUP function =VLOOKUP(lookup_value, table_array, column where return data is, false)**Function Wizard**• In excel there is a help tool for functions called the function wizard. • There are two ways to get the the function wizard. If you look at the standard toolbar, the function wizard icon look like the icon on the right. • The other way to get to the function wizard is to go to the menu INSERT -- down to FUNCTION.**Next Steps**• Add a range of useful functions to your spreadsheet – think why you are going to include them – don’t just include for the sake of it.**Help Sources**• Online tutorials • Help In Excel (PRESS f1)