エクセル事典

HOME »  五捨五超入 |  エクセル  | 放射線 | 統計学 | 教養数学 | コード表

  • Google （7関数） 2020.12.28
    ARRAYFORMULA  |  DETECTLANGUAGE  |  GOOGLEFINANCE  |  GOOGLETRNSLATE  |  IMAGE  |  QUERY  |  SPARKLINE

  • ウェブ （8関数） 2020.12.28
    ENCODEURL  |  HYPERLINK  |  IMPORTDATA  |  IMPORTFEED  |  IMPORTHTML  |  IMPORTRANGE  |  IMPORTXML  |  ISURL

  • エンジニアリング （41関数）
    BASE  |  BIN2DEC  |  BIN2HEX  |  BIN2OCT  |  COMPLEX  |  DEC2BIN  |  DEC2HEX  |  DEC2OCT  |  DECIMAL  |  DELTA  |  HEX2BIN  |  HEX2DEC  |  HEX2OCT  |  IMABS  |  IMAGINARY  |  IMARGUMENT  |  IMCONJUGATE  |  IMCOS  |  IMCOSH  |  IMCOT  |  IMCOTH  |  IMCSC  |  IMCSCH  |  IMDIV  |  IMEXP  |  IMLN  |  IMPOWER  |  IMPRODUCT  |  IMREAL  |  IMSEC  |  IMSECH  |  IMSIN  |  IMSINH  |  IMSQRT  |  IMSUB  |  IMSUM  |  IMTAN  |  IMTANH  |  OCT2BIN  |  OCT2DEC  |  OCT2HEX

  • テキスト （41関数） 2020.12.28
    ARABIC  |  ASC  |  CHAR  |  CLEAN  |  CODE  |  CONCATENATE  |  EXACT  |  FIND  |  FINDB  |  FIXED  |  JOIN  |  LEFT  |  LEFTB  |  LEN  |  LENB  |  LOWER  |  MID  |  MIDB  |  PROPER  |  REGEXEXTRACT  |  REGEXMATCH  |  REGEXREPLACE  |  REPLACE  |  REPLACEB  |  REPT  |  RIGHT  |  RIGHTB  |  ROMAN  |  SEARCH  |  SEARCHB  |  SPLIT  |  SUBSTITUTE  |  T  |  TEXT  |  TEXTJOIN  |  TRIM  |  UNICHAR  |  UNICODE  |  UPPER  |  VALUE  |  YEN

  • データベース （12関数）
    DAVERAGE  |  DCOUNT  |  DCOUNTA  |  DGET  |  DMAX  |  DMIN  |  DPRODUCT  |  DSTDEV  |  DSTDEVP  |  DSUM  |  DVAR  |  DVARP

  • パーサー （6関数） 2020.12.28
    CONVERT  |  TO_DATE  |  TO_DOLLARS  |  TO_PERCENT  |  TO_PURE_NUMBER  |  TO_TEXT

  • フィルタ （4関数） 2020.12.28
    FILTER  |  SORT  |  SORTN  |  UNIQUE

  • 会計 （51関数）
    ACCRINT  |  ACCRINTM  |  AMORLINC  |  BAHTTEXT  |  COUPDAYBS  |  COUPDAYS  |  COUPDAYSNC  |  COUPNCD  |  COUPNUM  |  COUPPCD  |  CUMIPMT  |  CUMPRINC  |  DB  |  DDB  |  DISC  |  DOLLARDE  |  DOLLARFR  |  DURATION  |  EFFECT  |  FV  |  FVSCHEDULE  |  INTRATE  |  IPMT  |  IRR  |  ISPMT  |  MDURATION  |  MIRR  |  NOMINAL  |  NPER  |  NPV  |  PDURATION  |  PMT  |  PPMT  |  PRICE  |  PRICEDISC  |  PRICEMAT  |  PV  |  RATE  |  RECEIVED  |  RRI  |  SLN  |  SYD  |  TBILLEQ  |  TBILLPRICE  |  TBILLYIELD  |  VDB  |  XIRR  |  XNPV  |  YIELD  |  YIELDDISC  |  YIELDMAT

  • 参照 （14関数）
    ADDRESS  |  CHOOSE  |  COLUMN  |  COLUMNS  |  GETPIVOTDATA  |  HLOOKUP  |  INDEX  |  INDIRECT  |  LOOKUP  |  MATCH  |  OFFSET  |  ROW  |  ROWS  |  VLOOKUP

  • 情報 （17関数） 2020.12.28
    CELL  |  ERROR.TYPE  |  FORMULATEXT  |  ISBLANK  |  ISEMAIL  |  ISERR  |  ISERROR  |  ISFORMULA  |  ISLOGICAL  |  ISNA  |  ISNONTEXT  |  ISNUMBER  |  ISREF  |  ISTEXT  |  N  |  NA  |  TYPE

  • 数学 （84関数） 2020.12.28
    ABS  |  ACOS  |  ACOSH  |  ACOT  |  ACOTH  |  ASIN  |  ASINH  |  ATAN  |  ATAN2  |  ATANH  |  CEILING  |  CEILING.MATH  |  CEILING.PRECISE  |  COMBIN  |  COMBINA  |  COS  |  COSH  |  COT  |  COTH  |  COUNTBLANK  |  COUNTIF  |  COUNTIFS  |  COUNTUNIQUE  |  CSC  |  CSCH  |  DEGREES  |  ERFC  |  ERFC.PRECISE  |  EVEN  |  EXP  |  FACT  |  FACTDOUBLE  |  FLOOR  |  FLOOR.MATH  |  FLOOR.PRECISE  |  GAMMA  |  GAMMALN  |  GAMMALN.PRECISE  |  GCD  |  IMLOG  |  IMLOG10  |  IMLOG2  |  INT  |  ISEVEN  |  ISO.CEILING  |  ISODD  |  LCM  |  LN  |  LOG  |  LOG10  |  MOD  |  MROUND  |  MULTINOMIAL  |  MUNIT  |  ODD  |  PHI  |  PI  |  POWER  |  PRODUCT  |  QUOTIENT  |  RADIANS  |  RAND  |  RANDARRAY  |  RANDBETWEEN  |  ROUND  |  ROUNDDOWN  |  ROUNDUP  |  SEC  |  SECH  |  SEQUENCE  |  SERIESSUM  |  SIGN  |  SIN  |  SINH  |  SQRT  |  SQRTPI  |  SUBTOTAL  |  SUM  |  SUMIF  |  SUMIFS  |  SUMSQ  |  TAN  |  TANH  |  TRUNC

  • 日付 （26関数） 2020.12.28
    DATE  |  DATEDIF  |  DATEVALUE  |  DAY  |  DAYS  |  DAYS360  |  EDATE  |  EOMONTH  |  HOUR  |  ISDATE  |  ISOWEEKNUM  |  MINUTE  |  MONTH  |  NETWORKDAYS  |  NETWORKDAYS.INTL  |  NOW  |  SECOND  |  TIME  |  TIMEVALUE  |  TODAY  |  WEEKDAY  |  WEEKNUM  |  WORKDAY  |  WORKDAY.INTL  |  YEAR  |  YEARFRAC

  • 演算子 （15関数） 2020.12.28
    ADD  |  CONCAT  |  DIVIDE  |  EQ  |  GT  |  GTE  |  LT  |  LTE  |  MINUS  |  MULTIPLY  |  NE  |  POW  |  UMINUS  |  UNARY_PERCENT  |  UPLUS

  • 統計 （136関数） 2020.12.28
    AVEDEV  |  AVERAGE  |  AVERAGE.WEIGHTED  |  AVERAGEA  |  AVERAGEIF  |  AVERAGEIFS  |  BETA.DIST  |  BETA.INV  |  BETADIST  |  BETAINV  |  BINOM.DIST  |  BINOM.DIST.RANGE  |  BINOM.INV  |  BINOMDIST  |  CHIDIST  |  CHISQ.DIST  |  CHISQ.DIST.RT  |  CHISQ.INV  |  CHISQ.INV.RT  |  CHISQ.TEST  |  CHITEST  |  CONFIDENCE  |  CONFIDENCE.NORM  |  CONFIDENCE.T  |  CORREL  |  COUNT  |  COUNTA  |  COUNTUNIQUEIFS  |  COVAR  |  COVARIANCE.P  |  COVARIANCE.S  |  CRITBINOM  |  DEVSQ  |  ERF  |  ERF.PRECISE  |  EXPON.DIST  |  EXPONDIST  |  F.DIST  |  F.DIST.RT  |  F.INV  |  F.INV.RT  |  F.TEST  |  FDIST  |  FINV  |  FISHER  |  FISHERINV  |  FORECAST  |  FORECAST.LINEAR  |  FTEST  |  GAMMA.DIST  |  GAMMA.INV  |  GAMMADIST  |  GAMMAINV  |  GAUSS  |  GEOMEAN  |  HARMEAN  |  HYPGEOM.DIST  |  HYPGEOMDIST  |  INTERCEPT  |  KURT  |  LARGE  |  LOGINV  |  LOGNORM.DIST  |  LOGNORM.INV  |  LOGNORMDIST  |  MAX  |  MAXA  |  MAXIFS  |  MEDIAN  |  MIN  |  MINA  |  MINIFS  |  MODE  |  MODE.MULT  |  MODE.SNGL  |  NEGBINOM.DIST  |  NEGBINOMDIST  |  NORM.DIST  |  NORM.INV  |  NORM.S.DIST  |  NORM.S.INV  |  NORMDIST  |  NORMINV  |  NORMSDIST  |  NORMSINV  |  PEARSON  |  PERCENTILE  |  PERCENTILE.EXC  |  PERCENTILE.INC  |  PERCENTRANK  |  PERCENTRANK.EXC  |  PERCENTRANK.INC  |  PERMUT  |  PERMUTATIONA  |  POISSON  |  POISSON.DIST  |  PROB  |  QUARTILE  |  QUARTILE.EXC  |  QUARTILE.INC  |  RANK  |  RANK.AVG  |  RANK.EQ  |  RSQ  |  SKEW  |  SKEW.P  |  SLOPE  |  SMALL  |  STANDARDIZE  |  STDEV  |  STDEV.P  |  STDEV.S  |  STDEVA  |  STDEVP  |  STDEVPA  |  STEYX  |  T.DIST  |  T.DIST.2T  |  T.DIST.RT  |  T.INV  |  T.INV.2T  |  T.TEST  |  TDIST  |  TINV  |  TRIMMEAN  |  TTEST  |  VAR  |  VAR.P  |  VAR.S  |  VARA  |  VARP  |  VARPA  |  WEIBULL  |  WEIBULL.DIST  |  Z.TEST  |  ZTEST

  • 論理 （17関数）
    AND  |  BITAND  |  BITLSHIFT  |  BITOR  |  BITRSHIFT  |  BITXOR  |  FALSE  |  GESTEP  |  IF  |  IFERROR  |  IFNA  |  IFS  |  NOT  |  OR  |  SWITCH  |  TRUE  |  XOR

  • 配列 （14関数） 2020.12.28
    ARRAY_CONSTRAIN  |  FREQUENCY  |  GROWTH  |  LINEST  |  LOGEST  |  MDETERM  |  MINVERSE  |  MMULT  |  SUMPRODUCT  |  SUMX2MY2  |  SUMX2PY2  |  SUMXMY2  |  TRANSPOSE  |  TREND

  • ExcelとGoogle 2020.12.28
    カテゴリ対応表

このサイトについて
  1. ブラウザを閉じるまでCookieに背景色を保存します。

外部リンク

HOME »  五捨五超入 |  エクセル  | 放射線 | 統計学 | 教養数学 | コード表