Excel Everywhere Supported Functions |
| ExcelEverywhere supports more than 150 of Excel's
built-in functions. ExcelEverywhere handles mathematical operations, text operations and advanced lookup operations. Click ' Complete function list' below for the list. |
Here is the list of functions supported by 3.1.6. We
are continuously adding new functions, if there is a
special one you need, let us know.Arithmetic and operators= > >= < <= <> + - * / % ^ LogicalIF AND OR NOT TRUE FALSE TextCHAR CLEAN CODE CONCATENATE DOLLAR EXACT FIND FIXED LEFT LEN LOWER MID PROPER REPLACE REPT RIGHT SEARCH SUBSTITUTE TEXT TRIM UPPER VALUE Math and TrigABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP FACT FLOOR INT LN LOG LOG10 MOD ODD PI POWER PRODUCT RADIANS RAND ROMAN ROUND ROUNDDOWN ROUNDUP SIGN SIN SINH SQRT SUM SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC Statistical FunctionsAVERAGE AVERAGEA AVEDEV CORREL COUNT COUNTA COUNTIF COVAR HYPGEOMDIST LARGE MAX MAXA MIN MINA NORMSDIST PEARSON RANK RSQ SLOPE SMALL STDEV STDEVA STDEVP STDEVPA VAR VARP VARA VARPA InformationISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT NA Lookup and ReferenceCHOOSE COLUMN COLUMNS HLOOKUP HYPERLINK INDEX LOOKUP MATCH ROW ROWS VLOOKUP Date and TimeDATE DATEVALUE DAY DAYS360 HOUR MINUTE MONTH NOW SECOND TIME TIMEVALUE TODAY WEEKDAY YEAR FinancialDB DDB FV IPMT IRR MIRR NPER NPV PMT PPMT PV RATE SLN SYD Analysis ToolpakQUOTIENT |