Numbers Functions v Numbers Functions (Missing function list)
Edit: yes i saw that the title says Numbers functions v numbers Functions, cant edit that after starting the tip part it seems
I have seen multiple posts asking what functions are supported in numbers versus which are supported in excel. (numbers functions list is here, An excel function list is here).
I have given out these links in the past, but have never seen anyone combine them into one "missing functions list" type of thing... so here goes.
The following list is of functions that Excel supports that are not included in numbers.
Followed by a list of functions in Numbers that are not supported in Excel.
Also, Note that Numbers does not allow a type of special formula/function in excel known as an array function. (Otherwise known as CSE formulas in some circles.) these formulas can be identified by surrounding "curly braces" { } when looking at the formulas.
I hope some people find this information useful.
Jason
Excel Functions not in numbers:
ACOT ACOTH AGGREGATE AMORDEGRC AMORLINC ARABIC ASC BAHTTEXT BASE BESSELI BESSELK BETA.DIST BETA.INV BINOM.DIST BINOM.DIST.RANGE BINOM.INV BITAND BITLSHIFT BITOR BITRSHIFT BITXOR CALL CEILING.MATH CEILING.PRECISE CELL CHISQ.DIST CHISQ.DIST.RT CHISQ.INV CHISQ.INV.RT CHISQ.TEST COMBINA COMPLEX CONCAT CONFIDENCE.NORM CONFIDENCE.T COT COTH COUPNCD COUPPCD COVARIANCE.P COVARIANCE.S CSC CSCH CUBEKPIMEMBER CUBEMEMBER CUBEMEMBERPROPERTY CUBERANKEDMEMBER CUBESET CUBESETCOUNT CUBEVALUE DAVERAGE DAYS DBCS DCOUNT DCOUNTA DECIMAL DGET DMAX DMIN DOLLARDE DOLLARFR DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP ENCODEURL ERF.PRECISE ERFC.PRECISE ERROR.TYPE EUROCONVERT EXPON.DIST F.DIST F.DIST.RT F.INV F.INV.RT F.TEST FILTER FILTERXML FISHER FISHERINV FLOOR.MATH FLOOR.PRECISE FORECAST.ETS FORECAST.ETS.CONFINT FORECAST.ETS.SEASONALITY FORECAST.ETS.STAT FORECAST.LINEAR FORMULATEXT FTEST FVSCHEDULE GAMMA GAMMA.DIST GAMMA.INV GAMMALN.PRECISE GAUSS GETPIVOTDATA GROWTH HYPERLINK HYPGEOM.DIST HYPGEOMDIST IFNA IFS IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMCOSH IMCOT IMCSC IMCSCH IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSEC IMSECH IMSIN IMSINH IMSQRT IMSUB IMSUM IMTAN INFO ISERR ISFORMULA ISLOGICAL ISNA ISNONTEXT ISNUMBER ISO.CEILING ISOWEEKNUM ISREF ISTEXT JIS KURT LOGEST LOGNORM.DIST LOGNORM.INV MAXIFS MDETERM MDURATION MINIFS MINVERSE MMULT MODE.MULT MODE.SNGL MUNIT N NA NEGBINOM.DIST NETWORKDAYS.INTL NORM.DIST NORM.INV NORM.S.DIST NORM.S.INV NUMBERVALUE ODDFPRICE ODDFYIELD ODDLPRICE ODDLYIELD PDURATION PEARSON PERCENTILE.EXC PERCENTILE.INC PERCENTRANK.EXC PERCENTRANK.INC PERMUTATIONA PHI PHONETIC POISSON.DIST QUARTILE.EXC QUARTILE.INC RANDARRAY RANK.AVG RANK.EQ REGISTER.ID RRI RSQ RTD SEC SECH SEQUENCE SHEET SHEETS SINGLE SKEW SKEW.P SORT SORTBY STDEV.P STDEV.S STEYX SUBTOTAL SWITCH T.DIST T.DIST.2T T.DIST.RT T.INV T.INV.2T T.TEST TBILLEQ TBILLPRICE TBILLYIELD TEXT TEXTJOIN TREND TRIMMEAN TYPE UNICHAR UNICODE UNIQUE VAR.P VAR.S WEBSERVICE WEIBULL.DIST WORKDAY.INTL XIRR XNPV XOR Z.TEST
Numbers Functions not in Excel
BASETONUM BONDDURATION BONDMDURATION DAYNAME DUR2DAYS DUR2HOURS DUR2MILLISECONDS DUR2MINUTES DUR2SECONDS DUR2WEEKS INTERSECT.RANGES MONTHNAME NUMTOBASE POLYNOMIAL STRIPDURATION UNION.RANGES
(This list is accurate with what information was available from Microsoft and Apple as of February 8th, 2019 from the links above.)