Documents To Go supports the majority of Excel spreadsheet functions. If a spreadsheet contains a function not supported by Documents To Go, the file will be locked on the device. Below is a list of Excel spreadsheet functions supported by Documents To Go. For more detailed information about each function, please refer to the Help file in Excel.

Name (@)ReturnsClassification
Unary –Subtraction negationArithmetic Operator
+AdditionArithmetic Operator
SubtractionArithmetic Operator
*MultiplicationArithmetic Operator
/DivisionArithmetic Operator
^ExponentiationArithmetic Operator
UnaryAdditionArithmetic Operator
=Equal toComparison Operator
<>Not equal toComparison Operator
<=Less than or equal toComparison Operator
>=Greater than or equal toComparison Operator
<Less thanComparison Operator
>Greater thanComparison Operator
&Connects, or concatenates, two values to produce one continuous text valueText Operator
DATE(yr, mon, day)The date number of yr, mon, dayDate & Time
DAY(date number)The day number of date numberDate & Time
HOUR(time number)The hour number of time numberDate & Time
MINUTE(time number)The minute number of time numberDate & Time
MONTH(date number)The month number of date numberDate & Time
NOW()The serial number for the current date and timeDate & Time
SECOND(time number)The second number of time numberDate & Time
TIME(hr, min, sec)The time number of hr, min, secDate & Time
TIMEVALUE(time_text)The year number of a dateDate & Time
TODAY()The serial number for the current dateDate & Time
WEEKDAY(date number, flags)The weekday number of date number (flags specifies what number gets mapped to what day)Date & Time
YEAR(date number)The year number of date numberDate & Time
DDB(cost, salvage, life, period, factor)Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specifyFinancial
FV(pmt, int, term)The future value of a series of equal payments, each of amount pmt, earning periodic interest rate int, over the number of payment periods in termFinancial
IRR(range, guess)The internal rate of return for the series of cash flows in range, based on the approximate percentage guess of the IRRFinancial
NPER(rate, pmt, pv, fv,type)The number of periods for an investment with interest rate per period, payment pmt for each period, present value pv, [and future value fv], base a constant rate, given the type(indicating payment due at the end (0) or beginning (1), default (0)Financial
NPV(int, range list)The present value of the series of future cash flows in range list, discounted at periodic interest rate intFinancial
PMT(prin, int, term)The amount of the periodic payment needed to pay off principle prin, at periodic interest rate int, over the number of payment periods in termFinancial
PV(pmt, int, term)The present value of a series of equal payments, each of amount pmt, discounted at periodic interest rate int, over the number of payment periods in termFinancial
RATE(nper, pmt, pv, fv,type, guess)The interest rate per period for an annuity with nper total number of payment periods, pmtpayment for each period, present value pv, [and future value fv], given the type (indicating payment due at the end (0) or beginning (1), default (0)Financial
SLN(cost, salvage, life)Returns the straight-line depreciation of an asset for one period.Financial
SYD(cost, salvage, life, per)Returns the sum-of-years’ digits depreciation of an asset for a specific period.Financial
AND(list)Returns TRUE if all its arguments are TRUE; returns FALSE if one or more arguments is FALSE.Logical
OR(list)Returns TRUE is any argument is TRUE; returns FALSE if all arguments are FALSE.Logical
NOT(x)Reverses the value of its argument.Logical
TRUE()Returns the logical value TRUE.Logical
FALSE()Returns the logical value FALSE.Logical
IF(cond, x, y)Returns x if condition is TRUE, and y if FALSELogical
CHOOSE(index, number, value1, value2)Returns a value from a list of values.Lookup & Reference
COLUMNS(array)Returns the number of columns in a reference.Lookup & Reference
HLOOKUP(x, range, row number, exact match)The contents of the cell in row row number which lies directly below the cell in the top row of range that matches xRow number is relative to the top of the table. The match to xmay or may not have to be anexact match.Lookup & Reference
INDEX(reference, row_num, column_num area_num)Uses an index to choose a value from a reference.Lookup & Reference
MATCH(lookup_value, lookup_reference, match_type)Looks up values in a referenceLookup & Reference
ROWS(array)Returns the number of rows in a referenceLookup & Reference
VLOOKUP(x, range, column number, exact match)The contents of the cell in column column number which lies directly across from the cell in the first column of range that matches x.Column number is relative to the left of the table. The match to x may or may not have to be an exact match.Lookup & Reference
ABS(x)The absolute value of xMath & Trig.
ACOS(x)The arc cosine of angle xMath & Trig.
ASIN(x)The arc sine of angle xMath & Trig.
ATAN(x)The arc tangent of angle xMath & Trig.
ATAN2(x, y)The arc tangent of angle y/xMath & Trig.
COS(x)The cosine of angle xMath & Trig.
COUNTIF(range, criteria)Counts the number of non-blank cells within a range that meet the given criteriaMath & Trig.
DEGREES(x)x*180/pMath & Trig.
EVEN (number)Rounds a number to nearest even integer. Negative numbers are adjusted away from zero.Math & Trig.
EXP(x)The number e raised to the xth powerMath & Trig.
FACT(number)Returns the factorial of a numberMath & Trig.
INT(x)Rounds a number down to the nearest integerMath & Trig.
LN(x)The natural log of xMath & Trig.
LOG(number, base)Returns the log of a number to a specified base.Math & Trig.
LOG10(x)The log (base 10) of xMath & Trig.
MOD(x, y)The remainder of x/yMath & Trig.
ODD (number)Rounds a number up to the nearest odd integer.Math & Trig.
PI()The number pMath & Trig.
POWER(number, power)Returns the result of a number raised to a power.Math & Trig.
PRODUCT(number1, number2)Multiplies its argumentsMath & Trig.
RADIANS(x)x*p/180Math & Trig.
ROUND(x, n)x rounded to n placesMath & Trig.
SIN(x)The sine of angle xMath & Trig.
SQRT(x)The positive square root of xMath & Trig.
SUM(list)The sum of the values in listMath & Trig.
SUMIF(range, criteria, sum_range)Adds the cells specified by a given criteriaMath & Trig.
TAN(x)The tangent of angle xMath & Trig.
TRUNC(number, num_digits)Truncates a number to an integerMath & Trig.
AVERAGE(list)The average of the values in listStatistical
COUNT(list)The number of non-blank entries in listStatistical
COUNTA(list)How many values are in the list of argumentsStatistical
COUNTBLANK(range)Counts the number of blank cells in a rangeStatistical
MAX(list)The maximum value in listStatistical
MIN(list)The minimum value in listStatistical
STDEV(list)The sample standard deviation of the values in listStatistical
STDEVP(list)The population standard deviation of the values in listStatistical
VAR(list)The sample variance of the values in listStatistical
VARP(list)The population variance of the values in listStatistical
CONCATENATE(string)Concatenates a list of strings or values togetherText
EXACT(text1, text2)Checks to see if two text values are identicalText
FIND(find_text, within_text, start_num)Finds one text value within another (case-sensitive)Text
LEFT(text, num_chars)Returns the leftmost characters from a text valueText
LEN(text)Returns the number of characters in a stringText
LOWER(text)<Text
MID(text, start_num, num_chars)Returns a specific number of characters from a text stringText
PROPER(text)Capitalizes the first letter in each word of a text valueText
REPLACE(old_text, start_num, num_chars, new_text)Replaces characters within textText
REPT(text, number_times)Repeats text a given number of timesText
RIGHT(text, num_chars)Returns the rightmost characters from a text valueText
SUBSITUTE(text, old_text, new_text, instance_num)Substitutes new text for old text in a text stringText
T(value)Converts its arguments to textText
TRIM(text)Removes spaces from textText
UPPER(text)Converts text to uppercaseText
VALUE(string)String that looks like a number in its actual numeric valueText
DAVERAGE(database, field, criteria)Averages the values in a column in a list or database that match conditions you specify.Database
DCOUNT(database, field, criteria)Counts the cells that contain numbers in a column in a list or database that match conditions you specify.Database
DCOUNTA(database, field, criteria)Counts the nonblank cells in a column in a list or database that match conditions you specify.Database
DGET(database, field, criteria)Extracts a single value from a column in a list or database that matches conditions you specify.Database
DMAX(database, field, criteria)Returns the largest number in a column in a list or database that matches conditions you specify.Database
DMIN(database, field, criteria)Returns the smallest number in a column in a list or database that matches conditions you specify.Database
DPRODUCT(database, field, criteria)Multiplies the values in a column in a list or database that matches conditions you specify.Database
DSTDEV(database, field, criteria)Estimates the standard deviation based on a sample, using the numbers in a column in a list or database that matches conditions you specify.Database
DSTDEVP(database, field, criteria)Calculates the standard deviation of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify.Database
DSUM(database, field, criteria)Adds the numbers in a column in a list or database that matches conditions you specify.Database
DVAR(database, field, criteria)Estimates variance based on a sample, using the numbers in a column in a list or database that matches conditions you specify.Database
DVARP(database, field, criteria)Calculates the variance of a population based on the entire population, using the numbers in a column in a list or database that matches conditions you specify.Database
ERROR.TYPE(error_val)Returns a number corresponding to an error typeInformational
ISBLANK(value)TRUE if the value is blankInformational
ISERR(value)TRUE if the value is any error except #N/AInformational
ISERROR(value)TRUE if the value is any error valueInformational
ISLOGICAL(value)TRUE if the value is a logical valueInformational
ISNA(value)TRUE if the value is the #N/AInformational
ISNONTEXT(value)TRUE if the value is not textInformational
ISNUMBER(value)TRUE if the value is a numberInformational
ISTEXT(value)TRUE if the value is textInformational
N(value)Returns a value converted to a numberInformational
NA()Returns the error value #N/AInformational