エクセル(EXCEL)関数-エクセルマニア

EXCELの関数の基本

合計・平均の関数	カウントの関数	四捨五入など	最大最小など
AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS MEDIAN MODE SUM SUMIF SUMIFS SUBTOTAL SUMPRODUCT	COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS FREQUENCY	CEILING EVEN FIXED FLOOR INT MOD MROUND ODD QUOTIENT ROUND ROUNDUP ROUNDDOWN TRUNC	LARGE MAX MIN RANK SMALL
日付の関数	時刻の関数	文字列の操作1	文字列の操作2
DATE DATEDIF DATESTRING DATEVALUE DAY EDATE EOMONTH MONTH NETWORKDAYS NETWORKDAYS.INTL NOW() TODAY() WEEKDAY WEEKNUM WORKDAY WORKDAY.INTL YEAR	HOUR MINUTE SECOND TIME TIMEVALUE	ASC FIND JIS LEFT LEN LENB LOWER MID NUMBERSTRING PHONETIC PROPER RIGHT SEARCH UPPER	CHAR CLEAN CODE CONCATENATE DOLLAR EXACT REPLACE REPT SUBSTITUTE TEXT TRIM YEN ＆(演算子)
検索/行列の関数	IF関数＆IS関数	三角関数・数学	データベース関数
ADDRESS CHOOSE COLUMN・COLUMNS HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW・ROWS TYPE VLOOKUP	AND EXACT IF IFERROR ISBLANK ISERROR N NA OR	ABS COS DEGREES EXP FACT LN LOG LOG10 PI() POWER RADIANS RAND RANDBETWEEN SIGN SIN SQRT TAN TEXT VALUE STDEV	DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DSUM
財務関数	エンジニアリング関数	情報関数
PMT PV FV RATE NPER	CONVERT	CELL INFO

A	B	C	D
ABS ADDRESS AND ASC AVEDEV AVERAGE AVERAGEA AVERAGEIF AVERAGEIFS		CEILING CEILING.PRECISE CELL CHAR CHITEST CHOOSE CLEAN COLUMN・COLUMNS CODE COMBIN CONCATENATE CONVERT CORREL COS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS COVAR	DATE DATEDIF DATESTRING DATEVALUE DAVERAGE DAY DCOUNT DCOUNTA DEGREES DGET DMAX DMIN DOLLAR DSUM
E	F	G	H
EDATE EOMONTH EVEN EXACT EXP	FACT FIND FIXED FLOOR FLOOR.PRECISE FREQUENCY FV	GCD GEOMEAN	HLOOKUP HOUR HYPERLINK HARMEAN
I	J	K	L
IF IFERROR INDEX INDIRECT INFO INT ISERROR ISBLANK IMABS IMAGINARY IMARGUMENT	JIS	KURT	LARGE LCM LEFT LEN LENB LN LOG LOG10 LOOKUP LOWER
M	N	O	P
MATCH MAX MEDIAN MID MIN MINUTE MINVERSE MMULT MOD MODE MONTH MROUND	N NA NETWORKDAYS NETWORKDAYS.INTL NOW NPER NUMBERSTRING	ODD OFFSET OR	PERMUT PHONETIC PI PMT POWER PROPER PERCENTILE PERCENTRANK
Q	R	S	T
QUOTIENT QUARTILE	RADIANS RAND RANDBETWEEN RANK RATE REPLACE REPT RIGHT ROUND ROUNDDOWN ROUNDUP ROW・ROWS	SEARCH SECOND SIGN SIN SKEW SMALL SQRT STDEV STDEVP STANDARDIZE SUBSTITUTE SUBTOTAL SUM SUMIF SUMIFS SUMPRODUCT	TAN TEXT TIME TIMEVALUE TODAY TRIM TRUNC TTEST TYPE TRIMMEAN
U	V	W	X
UPPER	VALUE VAR VARP VLOOKUP	WEEKDAY WEEKDAY WEEKNUM WORKDAY WORKDAY.INTL
Y	Z	その他
YEAR YEN	ZTEST	＆ * ？