Formulas Excel Advanced

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

IF: =IF(logicaltest,valueiftrue,valueif_false)

INDEX-MATCH: =INDEX(array,MATCH(lookupvalue,lookuparray,0))

SUMIF: =SUMIF(range,criteria,sum_range)

COUNTIF: =COUNTIF(range,criteria)

MAX: =MAX(range)

MIN: =MIN(range)

AVERAGE: =AVERAGE(range)

CONCATENATE: =CONCATENATE(text1,text2,…)

LEFT: =LEFT(text,num_chars)

RIGHT: =RIGHT(text,num_chars)

MID: =MID(text,startnum,numchars)

LEN: =LEN(text)

ROUND: =ROUND(number,num_digits)

ROUNDUP: =ROUNDUP(number,num_digits)

ROUNDDOWN: =ROUNDDOWN(number,num_digits)

IFERROR: =IFERROR(value,valueiferror)

SUMPRODUCT: =SUMPRODUCT(array1,array2,array3,…)

DATEVALUE: =DATEVALUE(date_text)

TODAY: =TODAY()

NOW: =NOW()

TEXT: =TEXT(value,format_text)

CHOOSE: =CHOOSE(index_num,value1,value2,…)

TRANSPOSE: =TRANSPOSE(array)

RAND: =RAND()