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
• 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;
• 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