Formulas Excel 5

SUM: =SUM(number1, number2, ...)

AVERAGE: =AVERAGE(number1, number2, ...)

MAX: =MAX(number1, number2, ...)

MIN: =MIN(number1, number2, ...)

COUNT: =COUNT(value1, value2, ...)

IF: =IF(logicaltest, valueiftrue, valueif_false)

INDEX: =INDEX(array, rownum, columnnum)

MATCH: =MATCH(lookupvalue, lookuparray, match_type)

VLOOKUP: =VLOOKUP(lookupvalue, tablearray, colindexnum, range_lookup)

CONCATENATE: =CONCATENATE(text1, text2, ...)