EXCEL SYNTAX

FUNCTION & FORMULA	SYNTAX
TIME	=	TIME(hour,minute,second)
TODAY	=	TODAY( )
DATE	=	DATE(YEAR,MONTH,DAY)
NOW	=	NOW( )
MAX	=	MAX(number1,number2,...)
MIN	=	MIN(number1,number2,...)
UPPER	=	UPPER(text)
PROPER	=	PROPER(text)
LOWER	=	LOWER(text)
COUNT	=	COUNT(value1, [value2],...)
COUNTA	=	COUNTA(value1, [value2], ...)
COUNTBLANK	=	COUNTBLANK(range)
COUNTIF	=	COUNTIF(range, criteria)
COUNTIFS	=	COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
AVERAGE	=	AVERAGE(number1, [number2],...)
SUM	=	SUM(number1, [number2], [number3], [number4], ...)
PRODUCT	=	PRODUCT(number1, [number2], ...)
SUMPRODUCT	=	SUMPRODUCT(array1,array2,array3, ...)
SUMIF	=	SUMIF(range, criteria, [sum_range])
SUMIFS	=	SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,criteria2], …)
IF	=	IF(LOGICAL_TEST,VALUE_IF TRUE,VALUE_IF_FALSE)
VLOOKUP	=	VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup])
HLOOKUP	=	HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
DATEVALUE	=	DATEVALUE(date_text)
TEXT	=	TEXT(value,format_text)
INDEX	=	INDEX(reference, row_num, [column_num], [area_num])
SEARCH	=	SEARCH(find_text,within_text,[start_num])
PV	=	PV(rate, nper, pmt, [fv], [type])
PMT	=	PMT(rate, nper, pv, [fv], [type])
FV	=	FV(rate, nper, pmt, [pv], [type])
EOMONTH	=	EOMONTH(start_date, months)
CONCATENATE	=	CONCAT(cell1, delimiter, cell2)
AVERAGEIF	=	AVERAGEIF(range, criteria, [average_range])
AVERAGEIFS	=	AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
IFS	=	IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3; ...)
LEFT	=	LEFT(TEXT,[NUM_CHARS])
MODE	=	MODE(number1,number2,...)
MEDIAN	=	MEDIAN(number1, [number2], ...)
NPER	=	NPER(rate,pmt,pv,[fv],[type])