Our support site has moved to https://support.intuiface.com

Excel Supported Formulas on Tablets and Kiosks

    NOTE: Some formulas might not work as expected. If any formula fails to work, please submit a ticket to our support website: http://support.intuilab.com

    • ABS;
    • ACOS;
    • ACOSH;
    • AND;
    • ASC; - Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
    • ASIN;
    • ASINH;
    • ATAN;
    • ATAN2;
    • ATANH;
    • AVERAGE;
    • AVERAGEA;
    • AVERAGEIF;
    • CEILING;
    • CHAR; - Returns the character specified by the code number
    • CLEAN; - Removes all nonprintable characters from text
    • CODE; - Returns a numeric code for the first character in a text string
    • COMBIN;
    • CONCATENATE; - Joins several text items into one text item
    • COS;
    • COSH;
    • COUNT;
    • COUNTA;
    • COUNTBLANK;
    • COUNTIF; - Works only with numbers. ex: COUNTIF(A1:A8,"=3") where A:A8 contains only numbers
    • DATE; - Returns the serial number of a particular date
    • DATEVALUE; - Converts a date in the form of text to a serial number
    • DAY; - Converts a serial number to a day of the month
    • DAYS360; - Calculates the number of days between two dates based on a 360-day year
    • DEGREES;
    • DOLLAR; - Converts a number to text, using the $ (dollar) currency format
    • EDATE; - Returns the serial number of the date that is the indicated number of months before or after the start date
    • EOMONTH; - Returns the serial number of the last day of the month before or after a specified number of months
    • EVEN;
    • EXACT; - Checks to see if two text values are identical
    • EXP;
    • FACT;
    • FACTDOUBLE;
    • FALSE;
    • FIND; -Finds one text value within another (case-sensitive)
    • FIXED; - Formats a number as text with a fixed number of decimals
    • FLOOR; - Rounds number down, toward zero, to the nearest multiple of significance
    • GCD;
    • HOUR; - Converts a serial number to an hour
    • HYPERLINK;
    • IF;
    • INT;
    • IRERROR;
    • LCM;
    • LEFT; - LEFTB Returns the leftmost characters from a text value
    • LEN; -, Returns the number of characters in a text string
    • LN;
    • LOG;
    • LOG10;
    • LOWER;- Converts text to lowercase
    • MAX;
    • MAXA;
    • MDETERM;
    • MID; - Returns a specific number of characters from a text string starting at the position you specify
    • MIN;
    • MINA;
    • MINUTE; - Converts a serial number to a minute
    • MINVERSE;
    • MMULT;
    • MOD";
    • MONTH; - Converts a serial number to a month
    • MROUND;
    • MULTINOMIAL;
    • NETWORKDAYS; - Returns the number of whole workdays between two dates
    • NOT;
    • NOW; - Returns the serial number of the current date and time
    • ODD;
    • OR;
    • PI;
    • POWER;
    • PRODUCT;
    • PROPER; - Capitalizes the first letter in each word of a text value
    • QUOTIENT;
    • RADIANS;
    • RAND;
    • RANDBETWEEN;
    • REPLACE; - Replaces characters within text
    • REPT; - Repeats text a given number of times
    • RIGHT; - Returns the rightmost characters from a text value
    • ROUND;
    • ROUNDDOWN;
    • ROUNDUP;
    • SEARCH; - Finds one text value within another (not case-sensitive)
    • SECOND; - Converts a serial number to a second
    • SERIESSUM;
    • SIGN;
    • SIN;
    • SINH;
    • SQRT;
    • SQRTPI;
    • STDEV;
    • STDEVA;
    • STDEVP;
    • STDEVPA;
    • SUBSTITUTE; - Substitutes new text for old text in a text string
    • SUBTOTAL;
    • SUM;
    • SUMIF;
    • SUMSQ;
    • T; - Converts its arguments to text
    • TAN;
    • TANH;
    • TEXT; - Formats a number and converts it to text
    • TIME; - Returns the serial number of a particular time
    • TIMEVALUE; - Converts a time in the form of text to a serial number
    • TODAY; - Returns the serial number of today's date
    • TRIM; - Removes spaces from text
    • TRUE;
    • TRUNC;
    • UPPER; - Converts text to uppercase
    • VALUE; - Converts a text argument to a number
    • VAR;
    • VARA;
    • VARP;
    • VARPA;
    • WEEKDAY; - Converts a serial number to a day of the week
    • WEEKNUM; - Converts a serial number to a number representing where the week falls numerically with a year
    • WORKDAY; - Returns the serial number of the date before or after a specified number of workdays
    • YEAR; - Converts a serial number to a year
    • YEARFRAC; - Returns the year fraction representing the number of whole days between startdate and enddate