Pocket Excel Unsupported Features
By Beverly Howard
Since there have been so many questions posted on
this,
the following is a list of the unsupported
formula functions within pocket excel on the PPC and smartphone
platform.
- ACCRINTM
- ACOSH
- ADDRESS
- AMORDEGRC
- AMORLINC
- AREAS
- ASC
- ASINH
- ATANH
- AVEDEV
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BAHTTEXT
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BETADIST
- BETAINV
- BIN2DEC
- BIN2HEX
- BIN2OCT
- BINOMDIST
- CEILING
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHITEST
- CLEAN
- CODE
- COLUMN
- COMBIN
- COMPLEX
- CONCATENATE
- CONFIDENCE
- CONVERT
- CORREL
- COSH
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- COVAR
- CRITBINOM
- CUBEKPIMEMBER
- CUBEMEMBER
- CUBEMEMBERPROPERTY
- CUBERANKEDMEMBER
- CUBESET
- CUBESETCOUNT
- CUBEVALUE
- CUMIPMT
- CUMPRINC
- DAYS360
- DB
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- DEVSQ
- DISC
- DMIN
- DOLLAR
- DOLLARDE
- DOLLARFR
- DURATION
- EDATE
- EFFECT
- EOMONTH
- ERF
- ERFC
- EUROCONVERT
- EVEN
- EXPONDIST
- FACTDOUBLE
- FDIST
- FINV
- FISHER
- FISHERINV
- FIXED
- FLOOR
- FORECAST
- FREQUENCY
- FTEST
- FVSCHEDULE
- GAMMADIST
- GAMMAINV
- GAMMALN
- GCD
- GEOMEAN
- GESTEP
- GETPIVOTDATA
- GROWTH
- HARMEAN
- HEX2BIN
- HEX2DEC
- HEX2OCT
- HYPERLINK
- HYPGEOMDIST
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- INDIRECT
- INFO
- INTERCEPT
- INTRATE
- IPMT
- ISEVEN
- ISODD
- ISPMT
- ISREF
- JIS
- KURT
- LARGE
- LCM
- LINEST
- LOGEST
- Logical
- LOGINV
- LOGNORMDIST
- LOOKUP
- MAXA
- MDETERM
- MDURATION
- MEDIAN
- MINA
- MINVERSE
- MIRR
- MMULT
- MODE
- MROUND
- MULTINOMIAL
- NEGBINOMDIST
- NETWORKDAYS
- NOMINAL
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- PHONETIC
- POISSON
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- QUARTILE
- QUOTIENT
- RANDBETWEEN
- RANK
- RECEIVED
- ROMAN
- ROUNDDOWN
- ROUNDUP
- ROW
- RSQ
- RTD
- SEARCH
- SERIESSUM
- SIGN
- SINH
- SKEW
- SLOPE
- SMALL
- SQL.REQUEST
- SQRTPI
- STANDARDIZE
- Statistical
- STDEVA
- STDEVPA
- STEYX
- SUBTOTAL
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TANH
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- TDIST
- TEXT
- TINV
- TODAY
- TRANSPOSE
- TREND
- TRIMMEAN
- TTEST
- TYPE
- VARA
- VARPA
- VDB
- WEEKDAY
- WEEKNUM
- WEIBULL
- WORKDAY
- XIRR
- XNPV
- YEARFRAC
- YIELD
- YIELDDISC
- YIELDMAT
- ZTEST
The following seem to be those specific to PC excel 2007
> AVERAGEIF
> AVERAGEIFS
> CUBEKPIMEMBER
> CUBEMEMBER
> CUBEMEMBERPROPERTY
> CUBERANKEDMEMBER
> CUBESET
> CUBESETCOUNT
> CUBEVALUE
> SUMIFS
Return
to Bev's Pocketpc Page