I'd already come across this some time ago and found that there are only 109 out of the 324 functions in Excel 97 implemented in Pocket Excel on the Jornada 720. (the 324 includes some 40 engineering functions that don't come as default with a standard installation and need to be enabled by a custom install of the analysis toolpack)

Below is a cut and past from a csv file I keep to hand on my desktop that shows which ones are available in Pocket Excel on the Jornada (marked by an x in the second column)

Hopefully If you paste this into a text file it should import into any *desktop* spreadsheet. For some obscure reason .csv or tab delimited text is not supported by Pocket Excel (much to my frustration, come on guys how difficult would it have been to provide this basic level of functionality?)

Excel 97 HPC2000 Excel 97 HPC2000 Excel 97 HPC2000 Excel 97 HPC2000
ABS x DOLLARDE ISNA x RANDBETWEEN
ACCRINT DOLLARFR ISNONTEXT x RANK
ACCRINTM DPRODUCT x ISNUMBER x RATE x
ACOS x DSTDEV x ISODD RECEIVED
ACOSH DSTDEVP x ISREF REPLACE x
ADDRESS DSUM x ISTEXT x REPT x
AMORDEGRC DURATION KURT RIGHT x
AMORLINC DVAR x LARGE ROMAN
AND x DVARP x LCM ROUND x
AREAS EDATE LEFT x ROUNDDOWN
ASIN x EFFECT LEN x ROUNDUP
ASINH EOMONTH LINEST ROW
ATAN x ERF LN x ROWS x
ATAN2 x ERFC LOG x RSQ
ATANH ERROR.TYPE x LOG10 x SEARCH
AVEDEV EVEN LOGEST SECOND x
AVERAGE x EXACT x LOGINV SERIESSUM
AVERAGEA EXP x LOGNORMDIST SIGN
BESSELI EXPONDIST LOOKUP SIN x
BESSELJ FACT x LOWER x SINH
BESSELK FACTDOUBLE MATCH x SKEW
BESSELY FALSE x MAX x SLN x
BETADIST FDIST MAXA SLOPE
BETAINV FIND x MDETERM SMALL
BIN2DEC FINV MDURATION SQRT x
BIN2HEX FISHER MEDIAN SQRTPI
BIN2OCT FISHERINV MID x STANDARDIZE
BINOMDIST FIXED MIN x STDEV x
CEILING FLOOR MINA STDEVA
CELL FORECAST MINUTE x STDEVP x
CHAR FREQUENCY MINVERSE STDEVPA
CHIDIST FTEST MIRR STEYX
CHIINV FV x MMULT SUBSTITUTE x
CHITEST FVSCHEDULE MOD x SUBTOTAL
CHOOSE x GAMMADIST MODE SUM x
CLEAN GAMMAINV MONTH x SUMIF x
CODE GAMMALN MROUND SUMPRODUCT
COLUMN GCD MULTINOMIAL SUMSQ
COLUMNS x GEOMEAN N x SUMX2MY2
COMBIN GESTEP NA x SUMX2PY2
COMPLEX GETPIVOTDATA NEGBINOMDIST SUMXMY2
CONCATENATE GROWTH NETWORKDAYS SYD x
CONFIDENCE HARMEAN NOMINAL T x
CONVERT HEX2BIN NORMDIST TAN x
CORREL HEX2DEC NORMINV TANH
COS x HEX2OCT NORMSDIST TBILLEQ
COSH HLOOKUP x NORMSINV TBILLPRICE
COUNT x HOUR x NOT x TBILLYIELD
COUNTA x HYPERLINK NOW x TDIST
COUNTBLANK x HYPGEOMDIST NPER x TEXT
COUNTIF x IF x NPV x TIME x
COUPDAYBS IMABS OCT2BIN TIMEVALUE x
COUPDAYS IMAGINARY OCT2DEC TINV
COUPDAYSNC IMARGUMENT OCT2HEX TODAY
COUPNCD IMCONJUGATE ODD TRANSPOSE
COUPNUM IMCOS ODDFPRICE TREND
COUPPCD IMDIV ODDFYIELD TRIM x
COVAR IMEXP ODDLPRICE TRIMMEAN
CRITBINOM IMLN ODDLYIELD TRUE x
CUMIPMT IMLOG10 OFFSET TRUNC x
CUMPRINC IMLOG2 OR x TTEST
DATE x IMPOWER PEARSON TYPE
DATEVALUE x IMPRODUCT PERCENTILE UPPER x
DAVERAGE x IMREAL PERCENTRANK VALUE x
DAY x IMSIN PERMUT VAR x
DAYS360 IMSQRT PI x VARA
DB IMSUB PMT x VARP x
DCOUNT x IMSUM POISSON VARPA
DCOUNTA x INDEX x POWER x VDB
DDB x INDIRECT PPMT VLOOKUP x
DEC2BIN INFO PRICE WEEKDAY
DEC2HEX INT x PRICEDISC WEIBULL
DEC2OCT INTERCEPT PRICEMAT WORKDAY
DEGREES x INTRATE PROB XIRR
DELTA IPMT PRODUCT x XNPV
DEVSQ IRR x PROPER x YEAR x
DGET x ISBLANK x PV x YEARFRAC
DISC ISERR x QUARTILE YIELD
DMAX x ISERROR x QUOTIENT YIELDDISC
DMIN x ISEVEN RADIANS x YIELDMAT
DOLLAR ISLOGICAL x RAND x ZTEST
CSV file of functions
| Home | Compatible Hardware | Keyboard Shortcuts | Excel Functions | Registry Edits | Wallpaper |