monthletFunctions you can use in spreadsheets
These are the functions you can use in formulas in a monthlet spreadsheet. Start a cell with "=" and type the first letters of a function name, and a list of matching functions appears. For commonly used functions, the arguments are shown as you type, as in SUM(number1, number2, …).
This list is from monthlet 1.1.1.
Math and trigonometry
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)
Statistical
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
Text
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 and time
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
Lookup and reference
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)
Logical
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, …)
Information
ERROR.TYPEISBLANK(value)ISERR(value)ISERROR(value)ISEVENISLOGICAL(value)ISNA(value)ISNONTEXTISNUMBER(value)ISREF(value)ISTEXT(value)NNATYPE
Engineering
BESSELIBESSELJBESSELKBESSELYBIN2DECBIN2HEXBIN2OCTBITANDBITLSHIFTBITORBITRSHIFTBITXORCOMPLEXDEC2BINDEC2HEXDEC2OCTDELTAERFERFCGESTEPHEX2BINHEX2DECHEX2OCTIMABSIMAGINARYIMARGUMENTIMCONJUGATEIMCOSIMCOSHIMCOTIMCSCIMCSCHIMDIVIMEXPIMLNIMLOG10IMLOG2IMPOWERIMPRODUCTIMREALIMSECIMSECHIMSINIMSINHIMSQRTIMSUBIMSUMIMTANOCT2BINOCT2DECOCT2HEX
Web
ENCODEURLWEBSERVICE
When you import an Excel file (.xlsx), formulas come in as their computed values.