![](https://blogimg.goo.ne.jp/user_image/2b/47/8baab7719ce0dea6ccefda71619a5b0c.jpg)
Excelのたいていの関数は、網羅されている。
Function | Category |
ABS | Math |
ACOS | Math |
ACOSH | Math |
ASIN | Math |
ASINH | Math |
ATAN | Math |
ATAN2 | Math |
ATANH | Math |
CEILING | Math |
COMBIN | Math |
COS | Math |
COSH | Math |
COUNT | Math |
COUNTA | Math |
COUNTBLANK | Math |
COUNTIF | Math |
DEGREES | Math |
EVEN | Math |
EXP | Math |
FACT | Math |
FACTDOUBLE | Math |
FLOOR | Math |
GCD | Math |
INT | Math |
LCM | Math |
LN | Math |
LOG | Math |
LOG10 | Math |
MDETERM | Math |
MINVERSE | Math |
MMULT | Math |
MOD | Math |
MROUND | Math |
MULTINOMIAL | Math |
ODD | Math |
PI | Math |
POWER | Math |
PRODUCT | Math |
QUOTIENT | Math |
RADIANS | Math |
RAND | Math |
RANDBETWEEN | Math |
ROUND | Math |
ROUNDDOWN | Math |
ROUNDUP | Math |
SERIESSUM | Math |
SIGN | Math |
SIN | Math |
SINH | Math |
SQRT | Math |
SQRTPI | Math |
SUM | Math |
SUMIF | Math |
SUMPRODUCT | Math |
SUMSQ | Math |
SUMX2MY2 | Math |
SUMX2PY2 | Math |
SUMXMY2 | Math |
TAN | Math |
TANH | Math |
TRUNC | Math |
ACCRINT | Financial |
ACCRINTM | Financial |
COUPDAYBS | Financial |
COUPDAYS | Financial |
COUPDAYSNC | Financial |
COUPNCD | Financial |
COUPNUM | Financial |
COUPPCD | Financial |
CUMIPMT | Financial |
CUMPRINC | Financial |
DB | Financial |
DDB | Financial |
DISC | Financial |
DOLLARDE | Financial |
DOLLARFR | Financial |
DURATION | Financial |
EFFECT | Financial |
FV | Financial |
FVSCHEDULE | Financial |
IPMT | Financial |
IRR | Financial |
MDURATION | Financial |
MIRR | Financial |
NOMINAL | Financial |
NPER | Financial |
NPV | Financial |
PMT | Financial |
PPMT | Financial |
PRICE | Financial |
PRICEDISC | Financial |
PRICEMAT | Financial |
PV | Financial |
RATE | Financial |
RECEIVED | Financial |
SLN | Financial |
SYD | Financial |
TBILLEQ | Financial |
TBILLPRICE | Financial |
TBILLYIELD | Financial |
XIRR | Financial |
XNPV | Financial |
YIELD | Financial |
YIELDDISC | Financial |
YIELDDISC | Financial |
AND | Logical |
IF | Logical |
NOT | Logical |
OR | Logical |
DATE | Date |
DATEVALUE | Date |
DAY | Date |
DAYS360 | Date |
EDATE | Date |
EOMONTH | Date |
MONTH | Date |
NETWORKDAYS | Date |
TODAY | Date |
WEEKDAY | Date |
WORKDAY | Date |
YEAR | Date |
YEARFRAC | Date |
ADDRESS | Lookup |
CHOOSE | Lookup |
COLUMN | Lookup |
COLUMNS | Lookup |
HLOOKUP | Lookup |
INDIRECT | Lookup |
OFFSET | Lookup |
ROW | Lookup |
ROWS | Lookup |
TRANSPOSE | Lookup |
VLOOKUP | Lookup |
AVEDEV | Statistical |
AVERAGE | Statistical |
AVERAGEA | Statistical |
BINOMDIST | Statistical |
CONFIDENCE | Statistical |
CORREL | Statistical |
COVAR | Statistical |
CRITBINOM | Statistical |
DEVSQ | Statistical |
EXPONDIST | Statistical |
FISHER | Statistical |
FISHERINV | Statistical |
FORECAST | Statistical |
FREQUENCY | Statistical |
GEOMEAN | Statistical |
GROWTH | Statistical |
HARMEAN | Statistical |
HYPGEOMDIST | Statistical |
INTERCEPT | Statistical |
KURT | Statistical |
LARGE | Statistical |
LINEST | Statistical |
LOGEST | Statistical |
LOGINV | Statistical |
LOGNORMDIST | Statistical |
MAX | Statistical |
MAXA | Statistical |
MEDIAN | Statistical |
MIN | Statistical |
MINA | Statistical |
MODE | Statistical |
NEGBINOMDIST | Statistical |
NORMDIST | Statistical |
NORMINV | Statistical |
NORMSDIST | Statistical |
NORMSINV | Statistical |
PEARSON | Statistical |
PERCENTILE | Statistical |
PERCENTRANK | Statistical |
PERMUT | Statistical |
POISSON | Statistical |
PROB | Statistical |
QUARTILE | Statistical |
RANK | Statistical |
RSQ | Statistical |
SKEW | Statistical |
SLOPE | Statistical |
SMALL | Statistical |
STANDARDIZE | Statistical |
STDEV | Statistical |
STDEVA | Statistical |
STDEVP | Statistical |
STDEVPA | Statistical |
STEYX | Statistical |
TREND | Statistical |
TRIMMEAN | Statistical |
VAR | Statistical |
VARA | Statistical |
VARP | Statistical |
VARPA | Statistical |
WEIBULL | Statistical |
ZTEST | Statistical |
CHAR | Text |
CODE | Text |
CONCATENATE | Text |
DOLLAR | Text |
EXACT | Text |
FIND | Text |
FIXED | Text |
LEFT | Text |
LEN | Text |
LOWER | Text |
MATCH | Text |
MID | Text |
PROPER | Text |
REPLACE | Text |
REPT | Text |
RIGHT | Text |
SEARCH | Text |
SUBSTITUTE | Text |
T | Text |
TEXT | Text |
TRIM | Text |
UPPER | Text |
VALUE | Text |
ERRORTYPE | Info |
ISBLANK | Info |
ISERR | Info |
ISERROR | Info |
ISEVEN | Info |
ISLOGICAL | Info |
ISNA | Info |
ISNONTEXT | Info |
ISNUMBER | Info |
ISODD | Info |
ISREF | Info |
ISTEXT | Info |
N | Info |
NA | Info |