エクセルマニア

EXCEL関数

TOP > 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

* ?