Spreadsheet: 118476d1313709989-excel-and-formula-training-copy-of-useful-functions-v1-4
Sheet: Sheet1

Useful Functions
 |  | Examples
Logical Functions
If - Returns value based on condition | IF(Condition, Value if TRUE, Value if FALSE)
Or - Returns TRUE if any listed condition is TRUE | OR(Condition1,Condition2,<Condition3>,...)
And - Returns TRUE if all listed conditions are TRUE | AND(Condition1, Condition2,<Condition3>,...)
Not - Makes FALSE into TRUE and vice-versa | NOT(Statement)
Testing Functions
IsError - Returns TRUE if the listed value returns an error | ISERROR(Expression)
IsNumber - Returns TRUE if the given expression is numeric | ISNUMBER(Expression)
IsBlank - Returns TRUE if the given reference is blank | ISBLANK(Reference)
IfError - Evalutes an expression and either returns its result or, if it gives an error, returns a selected expression | IFERROR(Expression,Value if error) |  | 0
Counting functions
Count - Counts the number of cells containing a number within a range | COUNT(Range)
CountA - Counts the number of non-blank cells in a range | COUNTA(Range)
CountIF - Counts the number of cells in a range meeting a given condition | COUNTIF(Range,Condition)
SumIF - Sums the cells in a range if the meeting a given condition | SUMIF(Range,Condition,<Range to Sum>)
Maths functions
Int - Returns the integer part of a number | INT(Number)
Round - Rounds a number to a set number of digits | ROUND(Number,Number of digits)
Abs - Converts a negative number to positive | ABS(Number)
[NAME] the largest number from a range or set | MAX(Value,<Value2>,<Value3>...)
Min - Returns the smallest number from a range or set | MIN(Value,<Value2>,<Value3>...)
String functions
[NAME] the length of a given string | LEN(String)
[NAME] the specified number of characters from the left hand side of a string | LEFT(String,Number of characters) |  | These
Right - Returns the specified number of characters from the right hand side of a string | RIGHT(String,Number of characters) |  | columns
Mid - Returns a specified number of characters from a starting point within a string | MID(String,Start point,Number of characters) |  | demonstrate
Trim - Removes leading and trailing spaces from a string | TRIM(String) |  | The
Upper - Forces a string into all upper case | UPPER(String) |  | VLOOKUP and HLOOKUP
Lower - Forces a string into all lower case | LOWER(String) |  | Functions
Substitute - Replaces one string with another in a larger string | [NAME],[NAME],[NAME])
Value - Returns the numeric value of a reference held as a string | VALUE(String)
Finding functions
Find - Finds text within another string, optionally starting at a specified character | FIND(Text To Find, Text To Search,<Character Number to start at>)
Vlookup - Finds text in the left-hand most column of a given range and returns the value from a specified columns on the same row | VLOOKUP(Text To Find,Range To Search,Column To Return,<Exact match?>)
Hlookup - Finds text in the uppermost row in a given range and returns the value from a specified row within the same column | HLOOKUP(Text To Find,Range to Search,Row To Return,<Exact match?>)
Match - Find a text in a specified range of cells and returns its position | MATCH(Text To Find, Range To Search,<Match Type>)
Miscellaneous functions
Offset - Returns the value in a cell a certain number of rows and columns from a reference point | OFFSET(Cell Reference,Row offset, Column offset)
Index - Return the specified value at the intersection of a given row and column for a range.  Normally used with 2 calls to the MATCH function to look up a reference on a table. | INDEX(Range,Row Position, Column Position)
Indirect - Converts a string into a range that can be used in formula | INDIRECT(Reference)