Difference between revisions of "Excel to Analytica Mappings"
 
(13 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
This page provides mappings from functions found in Excel to the equivalent method in Analytica.
+
[[Category: Excel to Analytica mappings]]
  
−
If you find a function where no translation is shown, this does not mean there isn't an equivalent. More likely, it just means that the equivalent hasn't been filled in yet.  Please contribute and fill it in! Note, in order to look at the Analytica equivalents under each category you will need to click on the subheading of the relevant category.
+
Most Excel functions have an equivalent in Analytica. Click on the headings below to see a list the Analytica equivalent for most Excel functions, either a function or expression.
  
 +
If you find a function with no equivalent, this does not mean there isn't one.  More likely, it just means no-one filled it in yet. Feel free to fill it in yourself! Or, email Lumina at support@Lumina.com, and we'll try to find one for you.  We haven't yet found anything you can do in Excel but not Analytica!
  
−
= [[Excel to Analytica Mappings/Database Functions|Database Functions]] =
+
'''[[Excel to Analytica Mappings/Database Functions|Database Functions]]:''' DAVERAGE
−
 
 
−
DAVERAGE
 
 
DCOUNT
 
DCOUNT
 
DCOUNTA
 
DCOUNTA
Line 19: Line 18:
 
DVARP
 
DVARP
  
−
= [[Excel to Analytica Mappings/Date and Time Functions|Date and Time Functions]] =
+
'''[[Excel to Analytica Mappings/Date and Time Functions|Date and Time Functions]]:''' DATE
−
 
 
−
DATE
 
 
DATEVALUE
 
DATEVALUE
 
DAY
 
DAY
Line 41: Line 38:
 
YEARFRAC
 
YEARFRAC
  
−
= [[Excel to Analytica Mappings/Engineering Functions|Engineering Functions]] =
+
''' [[Excel to Analytica Mappings/Engineering Functions|Engineering Functions]]:'''
−
 
 
 
BESSELI  
 
BESSELI  
 
BESSELJ  
 
BESSELJ  
Line 81: Line 77:
 
OCT2HEX
 
OCT2HEX
  
−
= [[Excel to Analytica Mappings/Financial Functions|Financial Functions]] =
+
''' [[Excel to Analytica Mappings/Financial Functions|Financial Functions]]:''' ACCRINT
−
 
 
−
ACCRINT
 
 
ACCRINTM
 
ACCRINTM
 
AMORDEGRC
 
AMORDEGRC
Line 137: Line 131:
 
YIELDMAT
 
YIELDMAT
  
−
= [[Excel to Analytica Mappings/Information Functions|Information Functions]] =
+
''' [[Excel to Analytica Mappings/Information Functions|Information Functions]]: '''
−
 
 
 
CELL
 
CELL
 
ERROR.TYPE
 
ERROR.TYPE
Line 157: Line 150:
 
TYPE
 
TYPE
  
−
= [[Excel to Analytica Mappings/Logical Functions|Logical Functions]] =
+
''' [[Excel to Analytica Mappings/Logical Functions|Logical Functions]]:''':
−
 
 
 
AND
 
AND
 
FALSE
 
FALSE
Line 166: Line 158:
 
TRUE
 
TRUE
  
−
= [[Excel to Analytica Mappings/Lookup Functions|Lookup Functions]] =
+
''' [[Excel to Analytica Mappings/Lookup Functions|Lookup Functions]]:'''
−
 
 
−
INDEX
 
 
ADDRESS
 
ADDRESS
 
AREAS
 
AREAS
Line 188: Line 178:
 
VLOOKUP
 
VLOOKUP
  
−
= [[Excel to Analytica Mappings/Math Functions|Math Functions]] =
+
''' [[Excel to Analytica Mappings/Math Functions|Math Functions]]:'''
−
 
 
 
ABS
 
ABS
 
ACOS
 
ACOS
Line 250: Line 239:
 
TRUNC
 
TRUNC
  
−
= [[Excel to Analytica Mappings/Statistical Functions|Statistical Functions]] =
+
''' [[Excel to Analytica Mappings/Statistical Functions|Statistical Functions]]:'''
−
 
 
 
AVEDEV
 
AVEDEV
 
AVERAGE
 
AVERAGE
Line 333: Line 321:
 
ZTEST
 
ZTEST
  
−
= [[Excel to Analytica Mappings/Text and Data Functions|Text and Data Functions]] =
+
''' [[Excel to Analytica Mappings/Text and Data Functions|Text and Data Functions]]:'''
−
 
 
 
ASC
 
ASC
 
BAHTTEXT
 
BAHTTEXT
Line 369: Line 356:
 
UPPER
 
UPPER
 
VALUE
 
VALUE
 +
 +
===See Also===
 +
<div style="column-count:2;-moz-column-count:2;-webkit-column-count:2">
 +
* [[Excel to Analytica Translation]]
 +
* [[Excel spreadsheets read and write]]
 +
* [[Functions To Read Excel Worksheets]]
 +
* [[Functions to Write Data to Excel Worksheets]]
 +
* [[Excel Functions from ADE]]
 +
* [[Excel to Analytica Mappings/Database Functions]]
 +
* [[Excel to Analytica Mappings/Date and Time Functions]]
 +
* [[Excel to Analytica Mappings/Engineering Functions]]
 +
* [[Excel to Analytica Mappings/Financial Functions]]
 +
* [[Excel to Analytica Mappings/Information Functions]]
 +
* [[Excel to Analytica Mappings/Logical Functions]]
 +
* [[Excel to Analytica Mappings/Lookup Functions]]
 +
* [[Excel to Analytica Mappings/Math Functions]]
 +
* [[Excel to Analytica Mappings/Statistical Functions]]
 +
* [[Excel to Analytica Mappings/Text and Data Functions]]
 +
 +
</div>

Latest revision as of 23:19, 9 February 2023


Most Excel functions have an equivalent in Analytica. Click on the headings below to see a list the Analytica equivalent for most Excel functions, either a function or expression.

If you find a function with no equivalent, this does not mean there isn't one. More likely, it just means no-one filled it in yet. Feel free to fill it in yourself! Or, email Lumina at support@Lumina.com, and we'll try to find one for you. We haven't yet found anything you can do in Excel but not Analytica!

Database Functions: DAVERAGE DCOUNT DCOUNTA DGET DMAX DMIN DPRODUCT DSTDEV DSTDEVP DSUM DVAR DVARP

Date and Time Functions: DATE DATEVALUE DAY DAYS360 EDATE EOMONTH HOUR MINUTE MONTH NETWORKDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WORKDAY YEAR YEARFRAC

Engineering Functions: BESSELI BESSELJ BESSELK BESSELY BIN2DEC BIN2HEX BIN2OCT COMPLEX CONVERT DEC2BIN DEC2HEX DEC2OCT DELTA ERF ERFC GESTEP HEX2BIN IMABS IMAGINARY IMARGUMENT IMCONJUGATE IMCOS IMDIV IMEXP IMLN IMLOG10 IMLOG2 IMPOWER IMPRODUCT IMREAL IMSIN IMSQRT IMSUB IMSUM OCT2BIN OCT2DEC OCT2HEX

Financial Functions: ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC DB DDB DISC DOLLARDE DOLLARFR DURATION EFFECT FV FVSCHEDULE INTRATE IMPT IRR ISPMT MDURATION MIRR NOMINAL NPER NPV ODDFPRICE ODDFYEILD ODDLPRICE ODDLYIELD PMT PPMT PRICE PRICEDISC PRICEMAT PV RATE RECEIVED SLN SYD TBILLEQ TBILLPRICE TBILLYIELD VDB XIRR XNPV YIELD YIELDDISC YIELDMAT

Information Functions: CELL ERROR.TYPE INFO ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT N NA TYPE

Logical Functions:: AND FALSE IF NOT OR TRUE

Lookup Functions: ADDRESS AREAS CHOOSE COLUMN COLUMNS GETPIVOTDATA HLOOKUP HYPERLINK INDEX INDIRECT LOOKUP MATCH OFFSET ROW ROWS RTD TRANSPOSE VLOOKUP

Math Functions: ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COS COSH DEGREES EVEN EXP FACT FACTDOUBLE FLOOR GCD INT LCM LN LOG LOG10 MDETERM MINVERSE MMULT MOD MROUND MULTINOMIAL ODD PI POWER PRODUCT QUOTIENT RADIANS RAND RANDBETWEEN ROMAN ROUND ROUNDDOWN ROUNDUP SERIESSUM SIGN SIG SINH SQRT SQRTPI SUBTOTAL SUM SUMIF SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2 SUMXMY2 TAN TANH TRUNC

Statistical Functions: AVEDEV AVERAGE AVERAGEA BETADIST BETAINV BINOMDIST CHIDIST CHIINV CHITEST CONFIDENCE CORREL COUNT COUNTA COUNTBLANK COUNTIF COVAR CRITBINOM DEVSQ EXPONDIST FDIST FINV FISHER FISHERINV FORECAST FREQUENCY FTEST GAMMADIST GAMMAINV GAMMALN GEOMEAN GROWTH HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LINEST LOGEST LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMDIST NORMINV NORMSDIST NORMSINV PEARSON PERCENTILE PERCENTRANK PERMUT POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TREND TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST

Text and Data Functions: ASC BAHTTEXT CHAR CLEAN CODE CONCATENATE COLLAR EXACT FIND FINDB FIXED JIS LEFT LEFTB LEN LENB LOWER MID MIDB PHONETIC PROPER REPLACE REPLACEB REPT RIGHT RIGHTB SEARCH SEARCHB SUBSTITUTE T TEXT TRIM UPPER VALUE

See Also

Comments


You are not allowed to post comments.