monthletスプレッドシートで使える関数
monthletのスプレッドシートの数式で使える関数の一覧です。セルに「=」を入れて関数名を打ち始めると、名前が合う関数の候補が表示されます。よく使う関数は、SUM(number1, number2, …)のように引数も入力中に表示されます。
monthlet 1.1.1の一覧です。
数学・三角
ABS(number)ACOSACOSHACOTACOTHARABICASINASINHATANATAN2ATANHBASECEILING(value, factor)CEILING.MATHCEILING.PRECISECOMBINCOMBINACOSCOSHCOTCOTHCSCCSCHDECIMALDEGREESEVENEXP(exponent)FACTFACTDOUBLEFLOOR(value, factor)FLOOR.MATHFLOOR.PRECISEGCD(value1, value2, …)INT(number)ISO.CEILINGLCM(value1, value2, …)LN(number)LOG(number, base)LOG10MDETERMMMULTMOD(dividend, divisor)MROUND(value, factor)MULTINOMIALMUNITODDPIPOWER(base, exponent)PRODUCT(number1, number2, …)QUOTIENT(dividend, divisor)RADIANSRANDRANDBETWEEN(low, high)ROMAN(number, form)ROUND(value, places)ROUNDDOWN(value, places)ROUNDUP(value, places)SECSECHSERIESSUMSIGN(number)SINSINHSQRT(number)SQRTPISUBTOTAL(function_num, range1, …)SUM(number1, number2, …)SUMIF(range, criterion, sum_range)SUMIFS(sum_range, criteria_range1, criterion1, …)SUMPRODUCT(array1, array2, …)SUMSQ(number1, number2, …)SUMX2MY2SUMX2PY2SUMXMY2TANTANHTRUNC(value, places)
統計
AVEDEVAVERAGE(number1, number2, …)AVERAGEA(value1, value2, …)AVERAGEIF(range, criterion, average_range)AVERAGEIFS(average_range, criteria_range1, criterion1, …)BETA.DISTBETA.INVBINOM.DISTBINOM.DIST.RANGEBINOM.INVCHISQ.DISTCHISQ.DIST.RTCHISQ.INVCHISQ.INV.RTCHISQ.TESTCONFIDENCE.NORMCONFIDENCE.TCORRELCOUNT(value1, value2, …)COUNTA(value1, value2, …)COUNTIF(range, criterion)COUNTIFS(criteria_range1, criterion1, …)COVARIANCE.PCOVARIANCE.SDEVSQEXPON.DISTF.DISTF.DIST.RTF.INVF.INV.RTF.TESTFISHERFISHERINVFORECASTFORECAST.LINEARFREQUENCYGAMMAGAMMA.DISTGAMMA.INVGAMMALNGAMMALN.PRECISEGAUSSGEOMEANGROWTHHARMEANHYPGEOM.DISTINTERCEPTKURTLARGE(array, k)LOGNORM.DISTLOGNORM.INVMAX(number1, number2, …)MAXA(value1, value2, …)MAXIFS(max_range, criteria_range1, criterion1, …)MEDIAN(number1, number2, …)MIN(number1, number2, …)MINA(value1, value2, …)MINIFS(min_range, criteria_range1, criterion1, …)MODE.SNGL(number1, number2, …)NEGBINOM.DISTNORM.DISTNORM.INVNORM.S.DISTNORM.S.INVPERCENTILE.INC(array, k)PHIPOISSON.DISTQUARTILE.INC(array, quart)RANK.AVG(number, ref, order)RANK.EQ(number, ref, order)SMALL(array, k)STANDARDIZESTDEV.P(number1, number2, …)STDEV.S(number1, number2, …)T.DISTT.DIST.2TT.DIST.RTT.INVT.INV.2TVAR.P(number1, number2, …)VAR.S(number1, number2, …)WEIBULL.DIST
文字列
ASCBAHTTEXTCHAR(number)CLEAN(text)CODE(string)CONCAT(value1, value2, …)CONCATENATE(string1, string2, …)DBCSDOLLAREXACT(text1, text2)FIND(search_for, text, start)FINDBFIXED(number, decimals, no_commas)LEFT(string, num_chars)LEFTBLEN(text)LENBLOWER(text)MID(string, start, num_chars)MIDBNUMBERVALUE(text, decimal_sep, group_sep)PROPER(text)REPLACE(text, position, length, new_text)REPLACEBREPT(text, count)RIGHT(string, num_chars)RIGHTBSEARCH(search_for, text, start)SEARCHBSUBSTITUTE(text, old_text, new_text, instance_num)TTEXT(value, format)TEXTJOIN(delimiter, ignore_empty, text1, …)TRIM(text)UNICHARUNICODE
日付と時刻
DATE(year, month, day)DATEDIF(start_date, end_date, unit)DATEVALUE(date_text)DAY(date)DAYS(end_date, start_date)DAYS360EDATE(start_date, months)EOMONTH(start_date, months)HOUR(time)ISOWEEKNUMMINUTE(time)MONTH(date)NETWORKDAYS(start_date, end_date, holidays)NETWORKDAYS.INTLNOWSECOND(time)TIME(hour, minute, second)TIMEVALUETODAYWEEKDAY(date, type)WEEKNUM(date, type)WORKDAY(start_date, days, holidays)WORKDAY.INTLYEAR(date)YEARFRAC
検索と参照
ADDRESS(row, column, abs_num, a1, sheet)AREASCHOOSE(index, value1, value2, …)COLUMN(reference)COLUMNS(range)HLOOKUP(search_key, range, index, is_sorted)INDEX(reference, row, column)INDIRECT(cell_reference_as_string)MATCH(search_key, range, match_type)ROW(reference)ROWS(range)TRANSPOSE(array)VLOOKUP(search_key, range, index, is_sorted)XLOOKUP(search_key, lookup_range, result_range, if_not_found, match_mode, search_mode)
論理
AND(logical1, logical2, …)FALSEIF(condition, value_if_true, value_if_false)IFERROR(value, value_if_error)IFNA(value, value_if_na)IFS(condition1, value1, …)NOT(logical)OR(logical1, logical2, …)SWITCH(expression, case1, value1, …)TRUEXOR(logical1, logical2, …)
情報
ERROR.TYPEISBLANK(value)ISERR(value)ISERROR(value)ISEVENISLOGICAL(value)ISNA(value)ISNONTEXTISNUMBER(value)ISREF(value)ISTEXT(value)NNATYPE
エンジニアリング
BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTBITANDBITLSHIFTBITORBITRSHIFTBITXORCOMPLEXDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMCOSHIMCOTIMCSCIMCSCHIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSECIMSECHIMSINIMSINHIMSQRTIMSUBIMSUMIMTANOCT2BINOCT2DECOCT2HEX
Web
ENCODEURLWEBSERVICE
Excelのファイル（.xlsx）を取り込むと、数式は計算結果の値として入ります。