MobileViews Blog

Excel Mobile Quick FAQs

Pocket Excel/Excel Mobile Quick FAQs

By Todd Ogasawara, MobileViews.com

The Quick FAQs page tries to provide answers to some of the most frequently asked questions about Pocket Excel on the Pocket PC. Starting with the Windows Mobile 5 platform release in 2005, Pocket Excel was renamed Excel Mobile.

You can find my article for Microsoft.com about the new features in Excel Mobile for Windows Mobile 5 at: What’s New in Excel Mobile.

Macros and Visual BASIC Scripting

Mobile Excel supports only a small subset of the features and capabilities found in the full version of Microsoft Excel. It does not support any kind of macros or scripting.

Graphing

Mobile Excel (part of the Microsoft Windows Mobile 5 for Pocket PC platform) can produce simple 2-D graphs including: Column, Bar, Line, Pie, XY (scatter), and Area.

Pocket Excel does not provide any of the graphing features provided by the full version of Microsoft Excel. However, DeveloperOne sells an add-on product for $9.95US that lets you create graphs using data from Pocket Excel. You can find it linked below:

DeveloperOne Pocket AutoGraph

POCKET EXCEL FUNCTIONS LIST

The functions available in Pocket Excel and Mobile Excel are listed below by function category. Note that these functions are a subset of the full range of functions available in the full version of Microsoft Excel.

Database

  • DAVERAGE(database,field,criteria)
  • DCOUNT(database,field,criteria)
  • DCOUNTA(database,field,criteria)
  • DGET(database,field,criteria)
  • DMAX(database,field,criteria)
  • DPRODUCT(database,field,criteria)
  • DSTDEV(database,field,criteria)
  • DSTDEVP(database,field,criteria)
  • DSUM(database,field,criteria)
  • DVAR(database,field,criteria)
  • DVARP(database,field,criteria)

Date & Time

  • DATE(year,month,day)
  • DATEVALUE(date_text)
  • DAY(serial_number)
  • HOUR(serial_number)
  • MINUTE(serial_number)
  • MONTH(serial_number)
  • NOW()
  • SECOND(serial_number)
  • TIME(hour,minute,second)
  • TIMEVALUE(time_text)
  • YEAR(serial_number)

Financial

  • DDB(cost,salvage,life,period,factor)
  • FV(rate,nper,pmt,pv,type)
  • IRR(values,guess)
  • NPER(rate,pmt,pv,fv,type)
  • NPV(rate,value1,value2,..)
  • PMT(rate,nper,pv,fv,type)
  • PV(rate,nper,pmt,fv,type)
  • RATE(nper,pmt,pv,fv,type,guess)
  • SLN(cost,salvage,life)
  • SYD(cost,salvage,life,per)

Informational

  • ERROR.TYPE(error_val)
  • ISBLANK(value)
  • ISERR(value)
  • ISERROR(value)
  • ISLOGICAL(value)
  • ISNA(value)
  • ISNONTEXT(value)
  • ISNUMBER(value)
  • ISTEXT(value)
  • N(value)
  • NA()

Logical

  • AND(logical1,logical2)
  • FALSE()
  • IF(logical_text_value,if_true_value,value_if_true,value_if_false)
  • NOT(logical)
  • OR(logical1,logical2)
  • TRUE()

Lookup

  • CHOOSE(index_num,value1,value2,…)
  • COLUMNS(array)
  • HLOOKUP(lookup_value,table_array,row_index_num,…)
  • INDEX(reference,row_num,column_num
  • MATCH(lookup_value,lookup_reference,match_type)
  • ROWS(array)
  • VLOOKUP(lookup_value,table_array,col_index_num,…)

Math & Trig

  • ABS(number)
  • ACOS(number)
  • ASIN(number)
  • ATAN(number)
  • ATAN2(x_num,y_num)
  • COS(number)
  • COUNTIF(range,criteria)
  • DEGREES(angle)
  • EXP(number)
  • FACT(number)
  • INT(number)
  • LN(number)
  • LOG(number,base)
  • LOG10((number)
  • MOD((number,divisor)
  • PI()
  • POWER(number,power)
  • PRODUCT(number1,number2,…)
  • RADIANS(angle)
  • RAND()
  • ROUND(number,num_digits)
  • SIN(number)
  • SQRT(number)
  • SUM(number1,number2,…)
  • SUMIF(range,criteria,sum_range)
  • TAN(number)
  • TRUNC(number,num_digits)

Statistical

  • AVERAGE(number1,number2,…)
  • COUNT(value1,value2,…)
  • COUNTA(value1,value2,…)
  • COUNTBLANK(range)
  • MAX(number1,number2,…)
  • MIN(number1,number2,…)
  • STDEV(number1,number2,…)
  • STDEVP(number1,number2,…)
  • VAR(number1,number2,…)
  • VARP(number1,number2,…)

Text

  • EXACT(text1,text2)
  • FIND(find_text,within_text,start_num)
  • LEFT(text,num_chars)
  • LEN(text)
  • LOWER(text)
  • MID(text,start_num,num_chars)
  • PROPER(text)
  • REPLACE(old_text,start_num,num_chars,new_text)
  • REPT(text,number_times)
  • RIGHT(text,num_chars)
  • SUBSTITUTE(text,old_text,new_text,instance_num)
  • T(value)
  • TRIM(text)
  • UPPER(text)
  • VALUE(text)

Pocket Excel Alternatives

If Pocket Excel does not meet your needs, there are two alternative spreadsheets for the Pocket PC available from third party developers. They are: