{"id":294,"date":"2007-05-14T22:27:59","date_gmt":"2007-05-15T08:27:59","guid":{"rendered":"http:\/\/www.mobileviews.com\/blog\/excel-mobile-functions-list\/"},"modified":"2007-05-14T22:29:01","modified_gmt":"2007-05-15T08:29:01","slug":"excel-mobile-functions-list","status":"publish","type":"page","link":"https:\/\/www.mobileviews.com\/blog\/excel-mobile-functions-list\/","title":{"rendered":"Excel Mobile Quick FAQs"},"content":{"rendered":"<p><!-- page body --><\/p>\n<h2>Pocket Excel\/Excel Mobile Quick FAQs<\/h2>\n<p><em>By Todd Ogasawara, MobileViews.com<\/em><\/p>\n<p>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 <em>Excel Mobile<\/em>.<\/p>\n<p>You can find my article for Microsoft.com about the new features in Excel Mobile for Windows Mobile 5 at: <a href=\"http:\/\/www.microsoft.com\/windowsmobile\/articles\/excelmobile.mspx\">What&#8217;s New in Excel Mobile<\/a>.<\/p>\n<h2>Macros and Visual BASIC Scripting<\/h2>\n<p>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.<\/p>\n<h2>Graphing<\/h2>\n<p><em>Mobile Excel<\/em> (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.<\/p>\n<p><em>Pocket Excel<\/em> 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:<\/p>\n<p><a href=\"http:\/\/www.developerone.com\/autograph\/index.htm\">DeveloperOne Pocket AutoGraph<\/a><\/p>\n<h2>POCKET EXCEL FUNCTIONS LIST<\/h2>\n<p>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.<\/p>\n<h2>Database<\/h2>\n<ul>\n<li>DAVERAGE(database,field,criteria)<\/li>\n<li>DCOUNT(database,field,criteria)<\/li>\n<li>DCOUNTA(database,field,criteria)<\/li>\n<li>DGET(database,field,criteria)<\/li>\n<li>DMAX(database,field,criteria)<\/li>\n<li>DPRODUCT(database,field,criteria)<\/li>\n<li>DSTDEV(database,field,criteria)<\/li>\n<li>DSTDEVP(database,field,criteria)<\/li>\n<li>DSUM(database,field,criteria)<\/li>\n<li>DVAR(database,field,criteria)<\/li>\n<li>DVARP(database,field,criteria)<\/li>\n<\/ul>\n<h2>Date &#038; Time<\/h2>\n<ul>\n<li>DATE(year,month,day)<\/li>\n<li>DATEVALUE(date_text)<\/li>\n<li>DAY(serial_number)<\/li>\n<li>HOUR(serial_number)<\/li>\n<li>MINUTE(serial_number)<\/li>\n<li>MONTH(serial_number)<\/li>\n<li>NOW()<\/li>\n<li>SECOND(serial_number)<\/li>\n<li>TIME(hour,minute,second)<\/li>\n<li>TIMEVALUE(time_text)<\/li>\n<li>YEAR(serial_number)<\/li>\n<\/ul>\n<h2>Financial<\/h2>\n<ul>\n<li>DDB(cost,salvage,life,period,factor)<\/li>\n<li>FV(rate,nper,pmt,pv,type)<\/li>\n<li>IRR(values,guess)<\/li>\n<li>NPER(rate,pmt,pv,fv,type)<\/li>\n<li>NPV(rate,value1,value2,..)<\/li>\n<li>PMT(rate,nper,pv,fv,type)<\/li>\n<li>PV(rate,nper,pmt,fv,type)<\/li>\n<li>RATE(nper,pmt,pv,fv,type,guess)<\/li>\n<li>SLN(cost,salvage,life)<\/li>\n<li>SYD(cost,salvage,life,per)<\/li>\n<\/ul>\n<h2>Informational<\/h2>\n<ul>\n<li>ERROR.TYPE(error_val)<\/li>\n<li>ISBLANK(value)<\/li>\n<li>ISERR(value)<\/li>\n<li>ISERROR(value)<\/li>\n<li>ISLOGICAL(value)<\/li>\n<li>ISNA(value)<\/li>\n<li>ISNONTEXT(value)<\/li>\n<li>ISNUMBER(value)<\/li>\n<li>ISTEXT(value)<\/li>\n<li>N(value)<\/li>\n<li>NA()<\/li>\n<\/ul>\n<h2>Logical<\/h2>\n<ul>\n<li>AND(logical1,logical2)<\/li>\n<li>FALSE()<\/li>\n<li>IF(logical_text_value,if_true_value,value_if_true,value_if_false)<\/li>\n<li>NOT(logical)<\/li>\n<li>OR(logical1,logical2)<\/li>\n<li>TRUE()<\/li>\n<\/ul>\n<h2>Lookup<\/h2>\n<ul>\n<li>CHOOSE(index_num,value1,value2,&#8230;)<\/li>\n<li>COLUMNS(array)<\/li>\n<li>HLOOKUP(lookup_value,table_array,row_index_num,&#8230;)<\/li>\n<li>INDEX(reference,row_num,column_num<\/li>\n<li>MATCH(lookup_value,lookup_reference,match_type)<\/li>\n<li>ROWS(array)<\/li>\n<li>VLOOKUP(lookup_value,table_array,col_index_num,&#8230;)<\/li>\n<\/ul>\n<h2>Math &#038; Trig<\/h2>\n<ul>\n<li>ABS(number)<\/li>\n<li>ACOS(number)<\/li>\n<li>ASIN(number)<\/li>\n<li>ATAN(number)<\/li>\n<li>ATAN2(x_num,y_num)<\/li>\n<li>COS(number)<\/li>\n<li>COUNTIF(range,criteria)<\/li>\n<li>DEGREES(angle)<\/li>\n<li>EXP(number)<\/li>\n<li>FACT(number)<\/li>\n<li>INT(number)<\/li>\n<li>LN(number)<\/li>\n<li>LOG(number,base)<\/li>\n<li>LOG10((number)<\/li>\n<li>MOD((number,divisor)<\/li>\n<li>PI()<\/li>\n<li>POWER(number,power)<\/li>\n<li>PRODUCT(number1,number2,&#8230;)<\/li>\n<li>RADIANS(angle)<\/li>\n<li>RAND()<\/li>\n<li>ROUND(number,num_digits)<\/li>\n<li>SIN(number)<\/li>\n<li>SQRT(number)<\/li>\n<li>SUM(number1,number2,&#8230;)<\/li>\n<li>SUMIF(range,criteria,sum_range)<\/li>\n<li>TAN(number)<\/li>\n<li>TRUNC(number,num_digits)<\/li>\n<\/ul>\n<h2>Statistical<\/h2>\n<ul>\n<li>AVERAGE(number1,number2,&#8230;)<\/li>\n<li>COUNT(value1,value2,&#8230;)<\/li>\n<li>COUNTA(value1,value2,&#8230;)<\/li>\n<li>COUNTBLANK(range)<\/li>\n<li>MAX(number1,number2,&#8230;)<\/li>\n<li>MIN(number1,number2,&#8230;)<\/li>\n<li>STDEV(number1,number2,&#8230;)<\/li>\n<li>STDEVP(number1,number2,&#8230;)<\/li>\n<li>VAR(number1,number2,&#8230;)<\/li>\n<li>VARP(number1,number2,&#8230;)<\/li>\n<\/ul>\n<h2>Text<\/h2>\n<ul>\n<li>EXACT(text1,text2)<\/li>\n<li>FIND(find_text,within_text,start_num)<\/li>\n<li>LEFT(text,num_chars)<\/li>\n<li>LEN(text)<\/li>\n<li>LOWER(text)<\/li>\n<li>MID(text,start_num,num_chars)<\/li>\n<li>PROPER(text)<\/li>\n<li>REPLACE(old_text,start_num,num_chars,new_text)<\/li>\n<li>REPT(text,number_times)<\/li>\n<li>RIGHT(text,num_chars)<\/li>\n<li>SUBSTITUTE(text,old_text,new_text,instance_num)<\/li>\n<li>T(value)<\/li>\n<li>TRIM(text)<\/li>\n<li>UPPER(text)<\/li>\n<li>VALUE(text)<\/li>\n<\/ul>\n<h2>Pocket Excel Alternatives<\/h2>\n<p>If Pocket Excel does not meet your needs, there are two alternative spreadsheets for the Pocket PC available from third party developers. They are:<\/p>\n<ul>\n<li><a href=\"http:\/\/www.byedesign.freeserve.co.uk\/\">Bye Design Ltd. SpreadCE<\/a><\/li>\n<li><a href=\"http:\/\/www.softmaker.com\/english\/pm_en.htm\">SoftMaker PlanMaker<\/a><\/li>\n<li><a href=\"http:\/\/www.z4soft.com\/ptab-spreadsheet\/\">Z4Soft PTab spreadsheet v.2.1<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-294","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/PpKRG-4K","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/pages\/294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/comments?post=294"}],"version-history":[{"count":0,"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/pages\/294\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mobileviews.com\/blog\/wp-json\/wp\/v2\/media?parent=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}