Difference between revisions of "Z API Functions"
Jump to navigation
Jump to search
| Line 603: | Line 603: | ||
*[[Manuals/calci/BESSELY | BESSELY]] | *[[Manuals/calci/BESSELY | BESSELY]] | ||
*[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]] | *[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]] | ||
| + | FINANCIAL1: | ||
| + | *[[Manuals/calci/ACCRINT | ACCRINT]] | ||
| + | *[[Manuals/calci/AMORLINC | AMORLINC]] | ||
| + | *[[Manuals/calci/CAGR | CAGR]] | ||
| + | *[[Manuals/calci/COUPDAYBS | COUPDAYBS]] | ||
| + | *[[Manuals/calci/COUPDAYS | COUPDAYS]] | ||
| + | *[[Manuals/calci/COUPDAYSNC | COUPDAYSNC]] | ||
| + | *[[Manuals/calci/COUPNCD | COUPNCD]] | ||
| + | *[[Manuals/calci/COUPNUM | COUPNUM]] | ||
| + | *[[Manuals/calci/COUPPCD | COUPPCD]] | ||
| + | *[[Manuals/calci/CUMIPMT | CUMIPMT]] | ||
| + | *[[Manuals/calci/CUMPRINC | CUMPRINC]] | ||
| + | *[[Manuals/calci/DB | DB]] | ||
| + | *[[Manuals/calci/DDB | DDB]] | ||
| + | *[[Manuals/calci/DISC | DISC]] | ||
| + | *[[Manuals/calci/DOLLAR | DOLLAR]] | ||
| + | *[[Manuals/calci/DOLLARDE | DOLLARDE]] | ||
| + | *[[Manuals/calci/DOLLARFR | DOLLARFR]] | ||
| + | *[[Manuals/calci/DURATION | DURATION]] | ||
| + | *[[Manuals/calci/EFFECT | EFFECT]] | ||
| + | *[[Manuals/calci/EFFECTBULGE | EFFECTBULGE]] | ||
| + | *[[Manuals/calci/EURO | EURO]] | ||
| + | *[[Manuals/calci/EUROCONVERT | EUROCONVERT]] | ||
| + | *[[Manuals/calci/FV | FV]] | ||
| + | *[[Manuals/calci/FVIF | FVIF]] | ||
| + | *[[Manuals/calci/FVIFA | FVIFA]] | ||
| + | *[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]] | ||
| + | *[[Manuals/calci/INTRATE | INTRATE]] | ||
| + | *[[Manuals/calci/IPMT | IPMT]] | ||
| + | *[[Manuals/calci/IRR | IRR]] | ||
| + | *[[Manuals/calci/ISPMT | ISPMT]] | ||
| + | *[[Manuals/calci/LOGEST | LOGEST]] | ||
| + | *[[Manuals/calci/MDURATION | MDURATION]] | ||
| + | *[[Manuals/calci/MIRR | MIRR]] | ||
| + | *[[Manuals/calci/NPER | NPER]] | ||
| + | *[[Manuals/calci/NPV | NPV]] | ||
| + | *[[Manuals/calci/PMT | PMT]] | ||
| + | *[[Manuals/calci/PMTLISTING | PMTLISTING]] | ||
| + | *[[Manuals/calci/PPMT | PPMT]] | ||
| + | *[[Manuals/calci/PV | PV]] | ||
| + | *[[Manuals/calci/PVEQUATION | PVEQUATION]] | ||
| + | *[[Manuals/calci/PVIF | PVIF]] | ||
| + | *[[Manuals/calci/PVIFA | PVIFA]] | ||
| + | *[[Manuals/calci/RATE | RATE]] | ||
| + | *[[Manuals/calci/RECEIVED | RECEIVED]] | ||
| + | *[[Manuals/calci/TBILLEQ | TBILLEQ]] | ||
| + | *[[Manuals/calci/TBILLPRICE | TBILLPRICE]] | ||
| + | *[[Manuals/calci/TBILLYIELD | TBILLYIELD]] | ||
| + | *[[Manuals/calci/USDOLLAR | USDOLLAR]] | ||
| + | *[[Manuals/calci/XNPV | XNPV]] | ||
| + | FINANCIAL2: | ||
| + | *[[Manuals/calci/ACCRINTM | ACCRINTM]] | ||
| + | *[[Manuals/calci/AMORDEGRC | AMORDEGRC]] | ||
| + | *[[Manuals/calci/NOMINAL | NOMINAL]] | ||
| + | *[[Manuals/calci/ODDFPRICE | ODDFPRICE]] | ||
| + | *[[Manuals/calci/ODDFYIELD | ODDFYIELD]] | ||
| + | *[[Manuals/calci/ODDLPRICE | ODDLPRICE]] | ||
| + | *[[Manuals/calci/ODDLYIELD | ODDLYIELD]] | ||
| + | *[[Manuals/calci/OPTIONSECURITY | OPTIONSECURITY]] | ||
| + | *[[Manuals/calci/PRICE | PRICE]] | ||
| + | *[[Manuals/calci/PRICEDISC | PRICEDISC]] | ||
| + | *[[Manuals/calci/PRICEMAT | PRICEMAT]] | ||
| + | *[[Manuals/calci/PUTOPTION | PUTOPTION]] | ||
| + | *[[Manuals/calci/SLN | SLN]] | ||
| + | *[[Manuals/calci/SYD | SYD]] | ||
| + | *[[Manuals/calci/VDB | VDB]] | ||
| + | *[[Manuals/calci/XIRR | XIRR]] | ||
| + | *[[Manuals/calci/YIELD | YIELD]] | ||
| + | *[[Manuals/calci/YIELDDISC | YIELDDISC]] | ||
| + | *[[Manuals/calci/YIELDMAT | YIELDMAT]] | ||
| + | *[[Manuals/calci/YMXC | YMXC]] | ||
| + | GEOMETRY AND GRAPH1: | ||
| + | *[[Manuals/calci/BARCHART | BARCHART]] | ||
| + | *[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]] | ||
| + | *[[Manuals/calci/CHORDDIAGRAM | CHORDDIAGRAM]] | ||
| + | *[[Manuals/calci/CHORDMATRIXDIAGRAM | CHORDMATRIXDIAGRAM]] | ||
| + | *[[Manuals/calci/CIRCLE | CIRCLE]] | ||
| + | *[[Manuals/calci/CIRCLEPACKING | CIRCLEPACKING]] | ||
| + | *[[Manuals/calci/CIRCLEWITHTEXT | CIRCLEWITHTEXT]] | ||
| + | *[[Manuals/calci/CUBE | CUBE]] | ||
| + | *[[Manuals/calci/CUBEDEV | CUBEDEV]] | ||
| + | *[[Manuals/calci/CURVE | CURVE]] | ||
| + | *[[Manuals/calci/DRAW | DRAW]] | ||
| + | *[[Manuals/calci/DRAWDATACURVE | DRAWDATACURVE]] | ||
| + | *[[Manuals/calci/DRAWSHAPE | DRAWSHAPE]] | ||
| + | *[[Manuals/calci/EDGEBUNDLING | EDGEBUNDLING]] | ||
| + | *[[Manuals/calci/ELLIPSE | ELLIPSE]] | ||
| + | *[[Manuals/calci/FROMTOGEOMETRIC | FROMTOGEOMETRIC]] | ||
| + | *[[Manuals/calci/FRACTAL | FRACTAL]] | ||
| + | *[[Manuals/calci/GEOMETRY | GEOMETRY]] | ||
| + | *[[Manuals/calci/GRAPH | GRAPH]] | ||
| + | *[[Manuals/calci/HYPOTENUSE | HYPOTENUSE]] | ||
| + | *[[Manuals/calci/INQUADRANT | INQUADRANT]] | ||
| + | *[[Manuals/calci/INQUADRANTSIGN | INQUADRANTSIGN]] | ||
| + | *[[Manuals/calci/INQUADRANTTHETA | INQUADRANTTHETA]] | ||
| + | *[[Manuals/calci/INTERCEPT | INTERCEPT]] | ||
| + | *[[Manuals/calci/LINE | LINE]] | ||
| + | *[[Manuals/calci/LISSAJOUS | LISSAJOUS]] | ||
| + | *[[Manuals/calci/LISSAJOUSCURVE | LISSAJOUSCURVE]] | ||
| + | *[[Manuals/calci/MAKEZCIRCLE | MAKEZCIRCLE]] | ||
| + | *[[Manuals/calci/MANDELBROT | MANDELBROT]] | ||
| + | *[[Manuals/calci/PIECHART | PIECHART]] | ||
| + | *[[Manuals/calci/PLOT | PLOT]] | ||
| + | *[[Manuals/calci/POINT | POINT]] | ||
| + | *[[Manuals/calci/POINTAT | POINTAT]] | ||
| + | *[[Manuals/calci/POLYGON | POLYGON]] | ||
| + | *[[Manuals/calci/RECTANGLE | RECTANGLE]] | ||
| + | *[[Manuals/calci/SHAPE | SHAPE]] | ||
| + | *[[Manuals/calci/SLOPE | SLOPE]] | ||
| + | *[[Manuals/calci/SOR | SOR]] | ||
| + | *[[Manuals/calci/SORT | SORT]] | ||
| + | *[[Manuals/calci/SPHERE | SPHERE]] | ||
| + | *[[Manuals/calci/SQUARES | SQUARES]] | ||
| + | *[[Manuals/calci/STAR | STAR]] | ||
| + | *[[Manuals/calci/STARS | STARS]] | ||
| + | *[[Manuals/calci/TETRA | TETRA]] | ||
| + | *[[Manuals/calci/TETRAHEDRON | TETRAHEDRON]] | ||
| + | *[[Manuals/calci/TETRAHEDRONDEV | TETRAHEDRONDEV]] | ||
| + | *[[Manuals/calci/TRIANGLE | TRIANGLE]] | ||
| + | *[[Manuals/calci/XYPOINT | XYPOINT]] | ||
| + | GEOMETRY AND GRAPH2: | ||
| + | *[[Manuals/calci/BUBBLECHART | BUBBLECHART]] | ||
| + | *[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]] | ||
| + | *[[Manuals/calci/CLUSTERDENDROGRAM | CLUSTERDENDROGRAM]] | ||
| + | *[[Manuals/calci/DRAGON | DRAGON]] | ||
| + | *[[Manuals/calci/FD | FD]] | ||
| + | *[[Manuals/calci/FDZ | FDZ]] | ||
| + | *[[Manuals/calci/filegeometry | filegeometry]] | ||
| + | *[[Manuals/calci/PLOTDEV | PLOTDEV]] | ||
| + | *[[Manuals/calci/STEMANDLEAFPLOT | STEMANDLEAFPLOT]] | ||
| + | *[[Manuals/calci/SURFACEGRAPH | SURFACEGRAPH]] | ||
| + | *[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]] | ||
| + | *[[Manuals/calci/TORUS | TORUS]] | ||
| + | INFORMATION1: | ||
| + | *[[Manuals/calci/APPLY | APPLY]] | ||
| + | *[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]] | ||
| + | *[[Manuals/calci/APPLYFUNCTIONTOELEMENTS | APPLYFUNCTIONTOELEMENTS]] | ||
| + | *[[Manuals/calci/APPLYFUNCTIONTORANGE | APPLYFUNCTIONTORANGE]] | ||
| + | *[[Manuals/calci/APPLYOF | APPLYOF]] | ||
| + | *[[Manuals/calci/APPLYTOALLKEYS | APPLYTOALLKEYS]] | ||
| + | *[[Manuals/calci/APPLYTOKEYS | APPLYTOKEYS]] | ||
| + | *[[Manuals/calci/ATOZ | ATOZ]] | ||
| + | *[[Manuals/calci/BADWORDS | BADWORDS]] | ||
| + | *[[Manuals/calci/BG | BG]] | ||
| + | *[[Manuals/calci/BILLION | BILLION]] | ||
| + | *[[Manuals/calci/BOLD | BOLD]] | ||
| + | *[[Manuals/calci/BOTTOM | BOTTOM]] | ||
| + | *[[Manuals/calci/BOTTOMN | BOTTOMN]] | ||
| + | *[[Manuals/calci/CALENDARPLOT | CALENDARPLOT]] | ||
| + | *[[Manuals/calci/CAPITALLETTERS | CAPITALLETTERS]] | ||
| + | *[[Manuals/calci/CELL | CELL]] | ||
| + | *[[Manuals/calci/COMMENTGET | COMMENTGET]] | ||
| + | *[[Manuals/calci/COMPARE | COMPARE]] | ||
| + | *[[Manuals/calci/CONS | CONS]] | ||
| + | *[[Manuals/calci/CONST | CONST]] | ||
| + | *[[Manuals/calci/CONSTANTS | CONSTANTS]] | ||
| + | *[[Manuals/calci/DE | DE]] | ||
| + | *[[Manuals/calci/DECLARE | DECLARE]] | ||
| + | *[[Manuals/calci/DECR | DECR]] | ||
| + | *[[Manuals/calci/EXEC | EXEC]] | ||
| + | *[[Manuals/calci/FORMATRANGE | FORMATRANGE]] | ||
| + | *[[Manuals/calci/FORMATWITHRANGES | FORMATWITHRANGES]] | ||
| + | *[[Manuals/calci/GDIM | GDIM]] | ||
| + | *[[Manuals/calci/GOALSEEK | GOALSEEK]] | ||
| + | *[[Manuals/calci/GOTO | GOTO]] | ||
| + | *[[Manuals/calci/GOV | GOV]] | ||
| + | *[[Manuals/calci/HEART | HEART]] | ||
| + | *[[Manuals/calci/HREF | HREF]] | ||
| + | *[[Manuals/calci/HTML | HTML]] | ||
| + | *[[Manuals/calci/HYPERLINK | HYPERLINK]] | ||
| + | *[[Manuals/calci/IN | IN]] | ||
| + | *[[Manuals/calci/INARRAY | INARRAY]] | ||
| + | *[[Manuals/calci/INCR | INCR]] | ||
| + | *[[Manuals/calci/ISARRAY | ISARRAY]] | ||
| + | *[[Manuals/calci/ISARRAYORSUCH | ISARRAYORSUCH]] | ||
| + | *[[Manuals/calci/ISARRAYORSUCHNOTSTRING | ISARRAYORSUCHNOTSTRING]] | ||
| + | *[[Manuals/calci/ISATOMICSYMBOL | ISATOMICSYMBOL]] | ||
| + | *[[Manuals/calci/ISBLANK | ISBLANK]] | ||
| + | *[[Manuals/calci/ISBOOLEAN | ISBOOLEAN]] | ||
| + | *[[Manuals/calci/ISCOMPLEX | ISCOMPLEX]] | ||
| + | *[[Manuals/calci/ISELEMENTLIKECOMPLEX | ISELEMENTLIKECOMPLEX]] | ||
| + | *[[Manuals/calci/ISEMPTY | ISEMPTY]] | ||
| + | *[[Manuals/calci/ISEQUATION | ISEQUATION]] | ||
| + | *[[Manuals/calci/ISERR | ISERR]] | ||
| + | *[[Manuals/calci/ISERROR | ISERROR]] | ||
| + | *[[Manuals/calci/ISEVEN | ISEVEN]] | ||
| + | *[[Manuals/calci/ISFUNCTION | ISFUNCTION]] | ||
| + | *[[Manuals/calci/ISFUNCTIONSYMBOL | ISFUNCTIONSYMBOL]] | ||
| + | *[[Manuals/calci/ISIGNOREINDEX | ISIGNOREINDEX]] | ||
| + | *[[Manuals/calci/ISINARRAY | ISINARRAY]] | ||
| + | *[[Manuals/calci/ISLAMBDAEQUATION | ISLAMBDAEQUATION]] | ||
| + | *[[Manuals/calci/ISLEAPYEAR | ISLEAPYEAR]] | ||
| + | *[[Manuals/calci/ISLIKELYTYPE | ISLIKELYTYPE]] | ||
| + | *[[Manuals/calci/ISLOCATION | ISLOCATION]] | ||
| + | *[[Manuals/calci/ISLOGICAL | ISLOGICAL]] | ||
| + | *[[Manuals/calci/ISLOWER | ISLOWER]] | ||
| + | *[[Manuals/calci/ISMONTH | ISMONTH]] | ||
| + | *[[Manuals/calci/ISNA | ISNA]] | ||
| + | *[[Manuals/calci/ISNONTEXT | ISNONTEXT]] | ||
| + | *[[Manuals/calci/ISNULL | ISNULL]] | ||
| + | *[[Manuals/calci/ISNULLLIKE | ISNULLLIKE]] | ||
| + | *[[Manuals/calci/ISNUMBER | ISNUMBER]] | ||
| + | *[[Manuals/calci/ISNUMBERSYMBOLS | ISNUMBERSYMBOLS]] | ||
| + | *[[Manuals/calci/ISOBJECT | ISOBJECT]] | ||
| + | *[[Manuals/calci/ISODD | ISODD]] | ||
| + | *[[Manuals/calci/ISOPERATORSYMBOL | ISOPERATORSYMBOL]] | ||
| + | *[[Manuals/calci/ISPERFECTNUMBER | ISPERFECTNUMBER]] | ||
| + | *[[Manuals/calci/ISPOINTLIKE | ISPOINTLIKE]] | ||
| + | *[[Manuals/calci/ISPRIME | ISPRIME]] | ||
| + | *[[Manuals/calci/ISRANGEOBJECT | ISRANGEOBJECT]] | ||
| + | *[[Manuals/calci/ISREF | ISREF]] | ||
| + | *[[Manuals/calci/ISREGEXP | ISREGEXP]] | ||
| + | *[[Manuals/calci/ISSAME | ISSAME]] | ||
| + | *[[Manuals/calci/ISSTRING | ISSTRING]] | ||
| + | *[[Manuals/calci/ISSUBSET | ISSUBSET]] | ||
| + | *[[Manuals/calci/ISSUPERSET | ISSUPERSET]] | ||
| + | *[[Manuals/calci/ISTEXT | ISTEXT]] | ||
| + | *[[Manuals/calci/ISVECTOR | ISVECTOR]] | ||
| + | *[[Manuals/calci/ISVECTORSIZE | ISVECTORSIZE]] | ||
| + | *[[Manuals/calci/ITALIC | ITALIC]] | ||
| + | *[[Manuals/calci/JIS | JIS]] | ||
| + | *[[Manuals/calci/KEYINARRAY | KEYINARRAY]] | ||
| + | *[[Manuals/calci/KEYS | KEYS]] | ||
| + | *[[Manuals/calci/KEYTAGS | KEYTAGS]] | ||
| + | *[[Manuals/calci/KNOW | KNOW]] | ||
| + | *[[Manuals/calci/LAZYOBJECT | LAZYOBJECT]] | ||
| + | *[[Manuals/calci/LAZYRANGE | LAZYRANGE]] | ||
| + | *[[Manuals/calci/LAZYSERIES | LAZYSERIES]] | ||
| + | *[[Manuals/calci/LIKE | LIKE]] | ||
| + | *[[Manuals/calci/LOAD | LOAD]] | ||
| + | *[[Manuals/calci/LOADSEMANTICINFO | LOADSEMANTICINFO]] | ||
| + | *[[Manuals/calci/LOL | LOL]] | ||
| + | *[[Manuals/calci/MAP | MAP]] | ||
| + | *[[Manuals/calci/MAPLISP | MAPLISP]] | ||
| + | *[[Manuals/calci/MAPTABLE | MAPTABLE]] | ||
| + | *[[Manuals/calci/MATCH | MATCH]] | ||
| + | *[[Manuals/calci/MILLION | MILLION]] | ||
| + | *[[Manuals/calci/MROWAGGREGATE | MROWAGGREGATE]] | ||
| + | *[[Manuals/calci/MROWDUPLICATE | MROWDUPLICATE]] | ||
| + | *[[Manuals/calci/MROWOP | MROWOP]] | ||
| + | *[[Manuals/calci/NA | NA]] | ||
| + | *[[Manuals/calci/NE | NE]] | ||
| + | *[[Manuals/calci/NES | NES]] | ||
| + | *[[Manuals/calci/NEST | NEST]] | ||
| + | *[[Manuals/calci/NIL | NIL]] | ||
| + | *[[Manuals/calci/NINTHOF | NINTHOF]] | ||
| + | *[[Manuals/calci/NO | NO]] | ||
| + | *[[Manuals/calci/NODE | NODE]] | ||
| + | *[[Manuals/calci/NODES | NODES]] | ||
| + | *[[Manuals/calci/NODESX | NODESX]] | ||
| + | *[[Manuals/calci/NODET | NODET]] | ||
| + | *[[Manuals/calci/NODEX | NODEX]] | ||
| + | *[[Manuals/calci/NONAME | NONAME]] | ||
| + | *[[Manuals/calci/NONE | NONE]] | ||
| + | *[[Manuals/calci/NUMERICARRAY | NUMERICARRAY]] | ||
| + | *[[Manuals/calci/OBJ | OBJ]] | ||
| + | *[[Manuals/calci/OBJECT | OBJECT]] | ||
| + | *[[Manuals/calci/OFF | OFF]] | ||
| + | *[[Manuals/calci/OFFSET | OFFSET]] | ||
| + | *[[Manuals/calci/OK | OK]] | ||
| + | *[[Manuals/calci/OLDX| OLDX]] | ||
| + | *[[Manuals/calci/ON | ON]] | ||
| + | *[[Manuals/calci/OPF | OPF]] | ||
| + | *[[Manuals/calci/OPFSTR | OPFSTR]] | ||
| + | *[[Manuals/calci/PFX | PFX]] | ||
| + | *[[Manuals/calci/PIGEN | PIGEN]] | ||
| + | *[[Manuals/calci/PIVOT | PIVOT]] | ||
| + | *[[Manuals/calci/RADIALTREE | RADIALTREE]] | ||
| + | *[[Manuals/calci/SQL | SQL]] | ||
| + | *[[Manuals/calci/SYMBOLFILTER | SYMBOLFILTER]] | ||
| + | *[[Manuals/calci/SYMBOLIC | SYMBOLIC]] | ||
| + | *[[Manuals/calci/SYMBOLNUMBER | SYMBOLNUMBER]] | ||
| + | *[[Manuals/calci/TABLE | TABLE]] | ||
| + | *[[Manuals/calci/TABLEADDROW | TABLEADDROW]] | ||
| + | *[[Manuals/calci/TABLEARRAY | TABLEARRAY]] | ||
| + | *[[Manuals/calci/TABLES | TABLES]] | ||
| + | *[[Manuals/calci/TABULATE | TABULATE]] | ||
| + | *[[Manuals/calci/TABULATEFORPIVOT | TABULATEFORPIVOT]] | ||
| + | *[[Manuals/calci/TAGS | TAGS]] | ||
| + | *[[Manuals/calci/THING | THING]] | ||
| + | *[[Manuals/calci/THINK | THINK]] | ||
| + | *[[Manuals/calci/TRUTHY | TRUTHY]] | ||
| + | *[[Manuals/calci/UNDERSTAND | UNDERSTAND]] | ||
| + | *[[Manuals/calci/UNDERSTANDSTRING | UNDERSTANDSTRING]] | ||
| + | *[[Manuals/calci/UNESCAPE | UNESCAPE]] | ||
| + | *[[Manuals/calci/UNICODESYMBOL | UNICODESYMBOL]] | ||
| + | *[[Manuals/calci/UNK | UNK]] | ||
| + | *[[Manuals/calci/UNKNOWN | UNKNOWN]] | ||
| + | *[[Manuals/calci/UNQUOTE | UNQUOTE]] | ||
| + | *[[Manuals/calci/XDY | XDY]] | ||
| + | *[[Manuals/calci/XML | XML]] | ||
| + | *[[Manuals/calci/XMLCALL | XMLCALL]] | ||
| + | *[[Manuals/calci/YES | YES]] | ||
| + | *[[Manuals/calci/YUP | YUP]] | ||
| + | INFORMATION2: | ||
| + | *[[Manuals/calci/ACRONYM | ACRONYM]] | ||
| + | *[[Manuals/calci/APOLOGIZE | APOLOGIZE]] | ||
| + | *[[Manuals/calci/BAHTTEXT | BAHTTEXT]] | ||
| + | *[[Manuals/calci/BYID | BYID]] | ||
| + | *[[Manuals/calci/CALLLISP | CALLLISP]] | ||
| + | *[[Manuals/calci/CALLOPTION | CALLOPTION]] | ||
| + | *[[Manuals/calci/CALLSQL | CALLSQL]] | ||
| + | *[[Manuals/calci/CANVASIMAGE | CANVASIMAGE]] | ||
| + | *[[Manuals/calci/COALESCE | COALESCE]] | ||
| + | *[[Manuals/calci/CONTAINS | CONTAINS]] | ||
| + | *[[Manuals/calci/CONTAINVISUALLY | CONTAINVISUALLY]] | ||
| + | *[[Manuals/calci/EXPORTTO | EXPORTTO]] | ||
| + | *[[Manuals/calci/EXPRESSMYOPINION | EXPRESSMYOPINION]] | ||
| + | *[[Manuals/calci/EXPRESSUSERSOPINION | EXPRESSUSERSOPINION]] | ||
| + | *[[Manuals/calci/MODEL | MODEL]] | ||
| + | *[[Manuals/calci/OCCURANCES | OCCURANCES]] | ||
| + | *[[Manuals/calci/PARTITIONP | PARTITIONP]] | ||
| + | *[[Manuals/calci/PARTITIONTREE | PARTITIONTREE]] | ||
| + | *[[Manuals/calci/PARTP | PARTP]] | ||
| + | *[[Manuals/calci/PFX | PFX]] | ||
| + | *[[Manuals/calci/READFROMLZWIMAGE | READFROMLZWIMAGE]] | ||
| + | *[[Manuals/calci/SDIM | SDIM]] | ||
| + | *[[Manuals/calci/SOSZ | SOSZ]] | ||
| + | *[[Manuals/calci/SOT | SOT]] | ||
| + | *[[Manuals/calci/SOV | SOV]] | ||
| + | *[[Manuals/calci/SOW | SOW]] | ||
| + | *[[Manuals/calci/SOWH | SOWH]] | ||
| + | *[[Manuals/calci/SOZ | SOZ]] | ||
| + | *[[Manuals/calci/TOSIMPLEARRAY | TOSIMPLEARRAY]] | ||
| + | *[[Manuals/calci/TRIGGEREVENT | TRIGGEREVENT]] | ||
| + | *[[Manuals/calci/TSV | TSV]] | ||
| + | *[[Manuals/calci/TTYL | TTYL]] | ||
| + | *[[Manuals/calci/URLEXPAND | URLEXPAND]] | ||
| + | *[[Manuals/calci/URLFRAMEEXPAND | URLFRAMEEXPAND]] | ||
| + | *[[Manuals/calci/URLLIST | URLLIST]] | ||
| + | *[[Manuals/calci/URLOBJECT | URLOBJECT]] | ||
| + | *[[Manuals/calci/URLS | URLS]] | ||
| + | *[[Manuals/calci/WHOISUSER | WHOISUSER]] | ||
| + | *[[Manuals/calci/XFUNCTIONAT | XFUNCTIONAT]] | ||
| + | *[[Manuals/calci/XMLDEPTH | XMLDEPTH]] | ||
| + | *[[Manuals/calci/XMLSET | XMLSET]] | ||
| + | *[[Manuals/calci/XMLTOTABLE | XMLTOTABLE]] | ||
| + | *[[Manuals/calci/XMLVALUES | XMLVALUES]] | ||
| + | *[[Manuals/calci/XMY | XMY]] | ||
| + | LOGICAL1: | ||
| + | *[[Manuals/calci/BITAND | BITAND]] | ||
| + | *[[Manuals/calci/BITLSHIFT | BITLSHIFT]] | ||
| + | *[[Manuals/calci/BITNOT | BITNOT]] | ||
| + | *[[Manuals/calci/BITOR | BITOR]] | ||
| + | *[[Manuals/calci/BITRSHIFT | BITRSHIFT]] | ||
| + | *[[Manuals/calci/BITRSHIFTZ | BITRSHIFTZ]] | ||
| + | *[[Manuals/calci/BITXOR | BITXOR]] | ||
| + | *[[Manuals/calci/FALSE | FALSE]] | ||
| + | *[[Manuals/calci/FALSEVALUE | FALSEVALUE]] | ||
| + | *[[Manuals/calci/FALSEY | FALSEY]] | ||
| + | *[[Manuals/calci/IF | IF]] | ||
| + | *[[Manuals/calci/IFNULL | IFNULL]] | ||
| + | *[[Manuals/calci/NOT | NOT]] | ||
| + | *[[Manuals/calci/NOTOK | NOTOK]] | ||
| + | *[[Manuals/calci/OR | OR]] | ||
| + | *[[Manuals/calci/TRUE | TRUE]] | ||
| + | *[[Manuals/calci/TRUEVALUE | TRUEVALUE]] | ||
| + | DATABASE AND LIST MANAGEMENT1: | ||
| + | *[[Manuals/calci/DAVERAGE | DAVERAGE]] | ||
| + | *[[Manuals/calci/DCOUNT | DCOUNT]] | ||
| + | *[[Manuals/calci/DCOUNTA | DCOUNTA]] | ||
| + | *[[Manuals/calci/DGET | DGET]] | ||
| + | *[[Manuals/calci/DMAX | DMAX]] | ||
| + | *[[Manuals/calci/DMIN | DMIN]] | ||
| + | *[[Manuals/calci/DSTDEV | DSTDEV]] | ||
| + | *[[Manuals/calci/DSTDEVP | DSTDEVP]] | ||
| + | *[[Manuals/calci/DSUM | DSUM]] | ||
| + | *[[Manuals/calci/DSV | DSV]] | ||
| + | *[[Manuals/calci/DVAR | DVAR]] | ||
| + | *[[Manuals/calci/DVARP | DVARP]] | ||
| + | DATABASE AND LIST MANAGEMENT2: | ||
| + | *[[Manuals/calci/DBPEDIA | DBPEDIA]] | ||
| + | *[[Manuals/calci/DIAG | DIAG]] | ||
| + | *[[Manuals/calci/DISPLAYXML | DISPLAYXML]] | ||
| + | *[[Manuals/calci/DOBY | DOBY]] | ||
| + | *[[Manuals/calci/DOCALLAFTER | DOCALLAFTER]] | ||
| + | *[[Manuals/calci/DOEFFECT | DOEFFECT]] | ||
| + | *[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]] | ||
| + | LOOKUP AND REFERENCE1: | ||
| + | *[[Manuals/calci/ADDRESS | ADDRESS]] | ||
| + | *[[Manuals/calci/AGE | AGE]] | ||
| + | *[[Manuals/calci/AREAS | AREAS]] | ||
| + | *[[Manuals/calci/BEEP | BEEP]] | ||
| + | *[[Manuals/calci/CHOOSE | CHOOSE]] | ||
| + | *[[Manuals/calci/COLORS | COLORS]] | ||
| + | *[[Manuals/calci/COLUMN | COLUMN]] | ||
| + | *[[Manuals/calci/COLUMNS | COLUMNS]] | ||
| + | *[[Manuals/calci/COLUMNWITH | COLUMNWITH]] | ||
| + | *[[Manuals/calci/COLWITH | COLWITH]] | ||
| + | *[[Manuals/calci/DONOTHING | DONOTHING]] | ||
| + | *[[Manuals/calci/DOSQL | DOSQL]] | ||
| + | *[[Manuals/calci/DROP | DROP]] | ||
| + | *[[Manuals/calci/DUPLICATE | DUPLICATE]] | ||
| + | *[[Manuals/calci/FIELDINDEX | FIELDINDEX]] | ||
| + | *[[Manuals/calci/FILTER | FILTER]] | ||
| + | *[[Manuals/calci/FORMULA | FORMULA]] | ||
| + | *[[Manuals/calci/FORRESULTSONLY | FORRESULTSONLY]] | ||
| + | *[[Manuals/calci/FUCTIONTOIMPLEMENT | FUCTIONTOIMPLEMENT]] | ||
| + | *[[Manuals/calci/FUNC | FUNC]] | ||
| + | FUNCT - *[[Manuals/calci/FUNCT | FUNCT]] | ||
| + | FUNCTIONFROMTEMPLATE - *[[Manuals/calci/FUNCTIONFROMTEMPLATE | FUNCTIONFROMTEMPLATE]] | ||
| + | FUNCTION OF - *[[Manuals/calci/FUNCTIONOF | FUNCTIONOF]] | ||
| + | FUZZY - *[[Manuals/calci/FUZZY | FUZZY]] | ||
| + | GETCOLUMN - *[[Manuals/calci/GETCOLUMN | GETCOLUMN]] | ||
| + | GETCONVERSION - *[[Manuals/calci/GETCONVERSION | GETCONVERSION]] | ||
| + | GETFUNCTION - *[[Manuals/calci/GETFUNCTION | GETFUNCTION]] | ||
| + | GETFUNCTION SET - *[[Manuals/calci/GETFUNCTIONSET | GETFUNCTIONSET]] | ||
| + | GET GPS -*[[Manuals/calci/GETGPS | GETGPS]] | ||
| + | GETJSON - *[[Manuals/calci/GETJSON | GETJSON]] | ||
| + | GET LINE- *[[Manuals/calci/GETLINE | GETLINE]] | ||
| + | GET NUMBER TAIL - *[[Manuals/calci/GETNUMBERTAIL | GETNUMBERTAIL]] | ||
| + | GET REAL OR COMPLEX - *[[Manuals/calci/GETREALORCOMPLEX | GETREALORCOMPLEX]] | ||
| + | GET ROW - *[[Manuals/calci/GETROW | GETROW]] | ||
| + | GET SERIES - *[[Manuals/calci/GETSERIES | GETSERIES]] | ||
| + | GMAP - *[[Manuals/calci/GMAP | GMAP]] | ||
| + | GOALSEEK - *[[Manuals/calci/GOALSEEK | GOALSEEK]] | ||
| + | GROUP - *[[Manuals/calci/GROUP | GROUP]] | ||
| + | HLOOKUP - *[[Manuals/calci/HLOOKUP | HLOOKUP]] | ||
| + | HVLOOKUP - *[[Manuals/calci/HVLOOKUP | HVLOOKUP]] | ||
| + | INDEX - *[[Manuals/calci/INDEX | INDEX]] | ||
| + | INDIRECT - *[[Manuals/calci/INDIRECT | INDIRECT]] | ||
| + | INFO - *[[Manuals/calci/INFO | INFO]] | ||
| + | INTEG - *[[Manuals/calci/INTEG | INTEG]] | ||
| + | LIST COLUMN LABELS - *[[Manuals/calci/LISTCOLUMNLABELS | LISTCOLUMNLABELS]] | ||
| + | LIST COLUMNS - *[[Manuals/calci/LISTCOLUMNS | LISTCOLUMNS]] | ||
| + | LIST ROWS - *[[Manuals/calci/LISTROWS | LISTROWS]] | ||
| + | LIST UNIQUE - *[[Manuals/calci/LISTUNIQUE | LISTUNIQUE]] | ||
| + | LISTV - *[[Manuals/calci/LISTV | LISTV]] | ||
| + | LOOKUP - *[[Manuals/calci/LOOKUP | LOOKUP]] | ||
| + | LOOP MEDIA - *[[Manuals/calci/LOOPMEDIA | LOOPMEDIA]] | ||
| + | MLANGUAGE LOOKUP - *[[Manuals/calci/MLANGUAGELOOKUP | MLANGUAGELOOKUP]] | ||
| + | NUMBER EIGHT - *[[Manuals/calci/NUMBEREIGHT | NUMBEREIGHT]] | ||
| + | NUMBER FIVE - *[[Manuals/calci/NUMBERFIVE | NUMBERFIVE]] | ||
| + | NUMBER FOUR - *[[Manuals/calci/NUMBERFOUR | NUMBERFOUR]] | ||
| + | NUMBER NINE - *[[Manuals/calci/NUMBERNINE | NUMBERNINE]] | ||
| + | NUMBER ONE - *[[Manuals/calci/NUMBERONE | NUMBERONE]] | ||
| + | NUMBER SEVEN - *[[Manuals/calci/NUMBERSEVEN | NUMBERSEVEN]] | ||
| + | NUMBER SIX - *[[Manuals/calci/NUMBERSIX | NUMBERSIX]] | ||
| + | NUMBER TEN - *[[Manuals/calci/NUMBERTEN | NUMBERTEN]] | ||
| + | NUMBER THREE - *[[Manuals/calci/NUMBERTHREE | NUMBERTHREE]] | ||
| + | NUMBER TWO - *[[Manuals/calci/NUMBERTWO | NUMBERTWO]] | ||
| + | NUMBER ZERO - *[[Manuals/calci/NUMBERZERO | NUMBERZERO]] | ||
| + | ONE - *[[Manuals/calci/ONE | ONE]] | ||
| + | ONE BY -*[[Manuals/calci/ONEBY | ONEBY]] | ||
| + | PARSE - *[[Manuals/calci/PARSE | PARSE]] | ||
| + | PARSE LISP - *[[Manuals/calci/PARSELISP | PARSELISP]] | ||
| + | PARSE NUMBER - *[[Manuals/calci/PARSENUMBER | PARSENUMBER]] | ||
| + | PARSE SQL - *[[Manuals/calci/PARSESQL | PARSESQL]] | ||
| + | PARSESTRING WITHOUT PARANTHESIS - *[[Manuals/calci/PARSESTRINGWITHOUTPARANTHESIS | PARSESTRINGWITHOUTPARANTHESIS]] | ||
| + | PASTE COLUMNS - *[[Manuals/calci/PASTECOLUMNS | PASTECOLUMNS]] | ||
| + | PASTE ROWS - *[[Manuals/calci/PASTEROWS | PASTEROWS]] | ||
| + | PAUSE - *[[Manuals/calci/PAUSE | PAUSE]] | ||
| + | QUOTE - *[[Manuals/calci/QUOTE | QUOTE]] | ||
| + | ROW - *[[Manuals/calci/ROW | ROW]] | ||
| + | ROWS - *[[Manuals/calci/ROWS | ROWS]] | ||
| + | ROW WITH - *[[Manuals/calci/ROWWITH | ROWWITH]] | ||
| + | SMILE - *[[Manuals/calci/SMILE | SMILE]] | ||
| + | UNDEFINED - *[[Manuals/calci/UNDEFINED | UNDEFINED]] | ||
| + | UPTO - *[[Manuals/calci/UPTO | UPTO]] | ||
| + | VLOOKUP - *[[Manuals/calci/VLOOKUP | VLOOKUP]] | ||
| + | |||
| + | |||
| + | Lookup and Reference2: | ||
| + | ANALYZE - *[[Manuals/calci/ANALYZE | ANALYZE]] | ||
| + | ASSIGN- *[[Manuals/calci/ASSIGN | ASSIGN]] | ||
| + | ASYNC ITERATE*[[Manuals/calci/ASYNCITERATE | ASYNCITERATE]] | ||
| + | ATTRTOPROP - *[[Manuals/calci/ATTRTOPROP | ATTRTOPROP]] | ||
| + | CASE - *[[Manuals/calci/CASE | CASE]] | ||
| + | CASEIF - *[[Manuals/calci/CASEIF | CASEIF]] | ||
| + | CDR - *[[Manuals/calci/CDR | CDR]] | ||
| + | EFFECT COLORBOOK - *[[Manuals/calci/EFFECTCOLORBOOK | EFFECTCOLORBOOK]] | ||
| + | EFFECTEDGEDETECTION - *[[Manuals/calci/EFFECTEDGEDETECTION | EFFECTEDGEDETECTION]] | ||
| + | EFFECTEDGEDETECTIONALGORITHM - *[[Manuals/calci/EFFECTEDGEDETECTIONALGORITHM | EFFECTEDGEDETECTIONALGORITHM]] | ||
| + | EFFECTGLASS - *[[Manuals/calci/EFFECTGLASS | EFFECTGLASS]] | ||
| + | EFFECTGLASSBOX - *[[Manuals/calci/EFFECTGLASSBOX | EFFECTGLASSBOX]] | ||
| + | EFFECT GLASS PATTERN -*[[Manuals/calci/EFFECTGLASSPATTERN | EFFECTGLASSPATTERN]] | ||
| + | EFFECTNEONLINES - *[[Manuals/calci/EFFECTNEONLINES | EFFECTNEONLINES]] | ||
| + | EFFECTPATTERN - *[[Manuals/calci/EFFECTPATTERN | EFFECTPATTERN]] | ||
| + | EFFECTRIPPLES - *[[Manuals/calci/EFFECTRIPPLES | EFFECTRIPPLES]] | ||
| + | GETCELLTD- *[[Manuals/calci/GETCELLTD | GETCELLTD]] | ||
| + | GETLATLONG - *[[Manuals/calci/GETLATLONG | GETLATLONG]] | ||
| + | GKMAPPING - *[[Manuals/calci/GKMAPPING | GKMAPPING]] | ||
| + | PENTATE - *[[Manuals/calci/PENTATE | PENTATE]] | ||
| + | QPIVOT - *[[Manuals/calci/QPIVOT | QPIVOT]] | ||
| + | QPIVOT IN CUBE - *[[Manuals/calci/QPIVOTINCUBE | QPIVOTINCUBE]] | ||
| + | SAFE EVAL - *[[Manuals/calci/SAFEEVAL | SAFEEVAL]] | ||
| + | STEP LOOP - *[[Manuals/calci/STEPLOOP | STEPLOOP]] | ||
| + | TIMER - *[[Manuals/calci/TIMER | TIMER]] | ||
| + | TIMES - *[[Manuals/calci/TIMES | TIMES]] | ||
| + | TIME STRING - *[[Manuals/calci/TIMESTRING | TIMESTRING]] | ||
| + | TYPE - *[[Manuals/calci/TYPE | TYPE]] | ||
| + | TZ - *[[Manuals/calci/TZ | TZ]] | ||
| + | XLBETWEEN - *[[Manuals/calci/XLBETWEEN | XLBETWEEN]] | ||
| + | XLR BETWEEN - *[[Manuals/calci/XLRBETWEEN | XLRBETWEEN]] | ||
| + | XPY - *[[Manuals/calci/XPY | XPY]] | ||
| + | XR BETWEEN - *[[Manuals/calci/XRBETWEEN | XRBETWEEN]] | ||
| + | XSY - *[[Manuals/calci/XSY | XSY]] | ||
| + | |||
| + | Text and Data1: | ||
| + | BADWORDS - *[[Manuals/calci/BADWORDS | BADWORDS]] | ||
| + | CHAR - *[[Manuals/calci/CHAR | CHAR]] | ||
| + | CHR-*[[Manuals/calci/CHR | CHR]] | ||
| + | CLAUSES - *[[Manuals/calci/CLAUSES | CLAUSES]] | ||
| + | CLEAN - *[[Manuals/calci/CLEAN | CLEAN]] | ||
| + | CLEAR - *[[Manuals/calci/CLEAR | CLEAR]] | ||
| + | CLS -*[[Manuals/calci/CLS | CLS]] | ||
| + | CODE - *[[Manuals/calci/CODE | CODE]] | ||
| + | DEFAULT - *[[Manuals/calci/DEFAULT | DEFAULT]] | ||
| + | DEFAULT NUMBER - *[[Manuals/calci/DEFAULTNUMBER | DEFAULTNUMBER]] | ||
| + | DEFAULT PROPER - *[[Manuals/calci/DEFAULTPROPER | DEFAULTPROPER]] | ||
| + | DEFUN - *[[Manuals/calci/DEFUN | DEFUN]] | ||
| + | DES - *[[Manuals/calci/DES | DES]] | ||
| + | DESCRIBEFUNCTIONCALLMISSING - *[[Manuals/calci/DESCRIBEFUNCTIONCALLMISSING | DESCRIBEFUNCTIONCALLMISSING]] | ||
| + | DEVARRAY - *[[Manuals/calci/DEVARRAY | DEVARRAY]] | ||
| + | DIM - *[[Manuals/calci/DIM | DIM]] | ||
| + | DIMENSIONS - *[[Manuals/calci/DIMENSIONS | DIMENSIONS]] | ||
| + | DIS - *[[Manuals/calci/DIS | DIS]] | ||
| + | EIGHTHOF - *[[Manuals/calci/EIGHTHOF | EIGHTHOF]] | ||
| + | ESCAPE - *[[Manuals/calci/ESCAPE | ESCAPE]] | ||
| + | EXTRACT NUMBERS - *[[Manuals/calci/EXTRACTNUMBERS | EXTRACTNUMBERS]] | ||
| + | EXTRACT TEXT - *[[Manuals/calci/EXTRACTTEXT | EXTRACTTEXT]] | ||
| + | FAIL - *[[Manuals/calci/FAIL | FAIL]] | ||
| + | FIND - *[[Manuals/calci/FIND | FIND]] | ||
| + | FINDB - *[[Manuals/calci/FINDB | FINDB]] | ||
| + | FINDUNIT - *[[Manuals/calci/FINDUNIT | FINDUNIT]] | ||
| + | FIXCHARS - *[[Manuals/calci/FIXCHARS | FIXCHARS]] | ||
| + | FIXED - *[[Manuals/calci/FIXED | FIXED]] | ||
| + | FIXED BAD- *[[Manuals/calci/FIXEDBAD | FIXEDBAD]] | ||
| + | FOR - *[[Manuals/calci/FOR | FOR]] | ||
| + | FOR ALL- *[[Manuals/calci/FORALL | FORALL]] | ||
| + | FOREACH - *[[Manuals/calci/FOREACH | FOREACH]] | ||
| + | FORLOOP - *[[Manuals/calci/FORLOOP | FORLOOP]] | ||
| + | LEFTB - *[[Manuals/calci/LEFTB | LEFTB]] | ||
| + | LEN - *[[Manuals/calci/LEN | LEN]] | ||
| + | LENB - *[[Manuals/calci/LENB | LENB]] | ||
| + | LETTERS - *[[Manuals/calci/LETTERS | LETTERS]] | ||
| + | LOWER - *[[Manuals/calci/LOWER | LOWER]] | ||
| + | LOWER CASE - *[[Manuals/calci/LOWERCASE | LOWERCASE]] | ||
| + | LZ - *[[Manuals/calci/LZ | LZ]] | ||
| + | LZWCOMPRESS - *[[Manuals/calci/LZWCOMPRESS | LZWCOMPRESS]] | ||
| + | LZWDECOMPRESS - *[[Manuals/calci/LZWDECOMPRESS | LZWDECOMPRESS]] | ||
| + | MID - *[[Manuals/calci/MID | MID]] | ||
| + | MIDB - *[[Manuals/calci/MIDB | MIDB]] | ||
| + | MIDDLE - *[[Manuals/calci/MIDDLE | MIDDLE]] | ||
| + | MIDN - *[[Manuals/calci/MIDN | MIDN]] | ||
| + | MIXED CASE - *[[Manuals/calci/MIXEDCASE | MIXEDCASE]] | ||
| + | NOK - *[[Manuals/calci/NOK | NOK]] | ||
| + | NON FALSE VALUE - *[[Manuals/calci/NONFALSEVALUE | NONFALSEVALUE]] | ||
| + | NON NEGATIVE - *[[Manuals/calci/NONNEGATIVE | NONNEGATIVE]] | ||
| + | NON POSITIVE - *[[Manuals/calci/NONPOSITIVE | NONPOSITIVE]] | ||
| + | NON ZERO - *[[Manuals/calci/NONZERO | NONZERO]] | ||
| + | NON ZERO VALUE - *[[Manuals/calci/NONZEROVALUE | NONZEROVALUE]] | ||
| + | NOPE - *[[Manuals/calci/NOPE | NOPE]] | ||
| + | NOW - *[[Manuals/calci/NOW | NOW]] | ||
| + | NULL - *[[Manuals/calci/NULL | NULL]] | ||
| + | NULL IF - *[[Manuals/calci/NULLIF | NULLIF]] | ||
| + | NUM - *[[Manuals/calci/NUM | NUM]] | ||
| + | NUMBER - *[[Manuals/calci/NUMBER | NUMBER]] | ||
| + | NVL - *[[Manuals/calci/NVL | NVL]] | ||
| + | OSTYLE - *[[Manuals/calci/OSTYLE | OSTYLE]] | ||
| + | OUTPUT - *[[Manuals/calci/OUTPUT | OUTPUT]] | ||
| + | PACK - *[[Manuals/calci/PACK | PACK]] | ||
| + | PADZEROES - *[[Manuals/calci/PADZEROES | PADZEROES]] | ||
| + | PHONETIC - *[[Manuals/calci/PHONETIC | PHONETIC]] | ||
| + | PHONETIC CODES - *[[Manuals/calci/PHONETICCODES | PHONETICCODES]] | ||
| + | PRINT - *[[Manuals/calci/PRINT | PRINT]] | ||
| + | PRINT CONVERSION - *[[Manuals/calci/PRINTCONVERSION | PRINTCONVERSION]] | ||
| + | PRINTTAGS - *[[Manuals/calci/PRINTTAGS | PRINTTAGS]] | ||
| + | PRINT UNIT TAGS - *[[Manuals/calci/PRINTUNITTAGS | PRINTUNITTAGS]] | ||
| + | PRINT WITH UNITS - *[[Manuals/calci/PRINTWITHUNITS | PRINTWITHUNITS]] | ||
| + | PROPER - *[[Manuals/calci/PROPER | PROPER]] | ||
| + | PUSH - *[[Manuals/calci/PUSH | PUSH]] | ||
| + | REMOVE TEXT - *[[Manuals/calci/REMOVETEXT | REMOVETEXT]] | ||
| + | REPEAT CHAR - *[[Manuals/calci/REPEATCHAR | REPEATCHAR]] | ||
| + | REPLACE - *[[Manuals/calci/REPLACE | REPLACE]] | ||
| + | REPLACE ARRAY - *[[Manuals/calci/REPLACEARRAY | REPLACEARRAY]] | ||
| + | REPLACEB - *[[Manuals/calci/REPLACEB | REPLACEB]] | ||
| + | REPLACE BAD - *[[Manuals/calci/REPLACEBAD | REPLACEBAD]] | ||
| + | REPT - *[[Manuals/calci/REPT | REPT]] | ||
| + | REVERSE - *[[Manuals/calci/REVERSE | REVERSE]] | ||
| + | RIGHTB - *[[Manuals/calci/RIGHTB | RIGHTB]] | ||
| + | RTD - *[[Manuals/calci/RTD | RTD]] | ||
| + | SEARCH - *[[Manuals/calci/SEARCH | SEARCH]] | ||
| + | SEARCHB - *[[Manuals/calci/SEARCHB | SEARCHB]] | ||
| + | SEARCH BOX SPACE - *[[Manuals/calci/SearchBoxSpace | SearchBoxSpace]] | ||
| + | SEQ - *[[Manuals/calci/SEQ | SEQ]] | ||
| + | SET VALUE STRING - *[[Manuals/calci/SETVALUESTRING | SETVALUESTRING]] | ||
| + | SET WHOISUSER - *[[Manuals/calci/SETWHOISUSER | SETWHOISUSER]] | ||
| + | SLIDER CONTROL - *[[Manuals/calci/SLIDERCONTROL | SLIDERCONTROL]] | ||
| + | SO - *[[Manuals/calci/SO | SO]] | ||
| + | SOB - *[[Manuals/calci/SOB | SOB]] | ||
| + | SOC - *[[Manuals/calci/SOC | SOC]] | ||
| + | SOH - *[[Manuals/calci/SOH | SOH]] | ||
| + | SOI - *[[Manuals/calci/SOI | SOI]] | ||
| + | SOL - *[[Manuals/calci/SOL | SOL]] | ||
| + | SOLT - *[[Manuals/calci/SOLT | SOLT]] | ||
| + | SOLTWH - *[[Manuals/calci/SOLTWH | SOLTWH]] | ||
| + | *[[Manuals/calci/SOME | SOME]] | ||
| + | *[[Manuals/calci/SPELLDIGIT | SPELLDIGIT]] | ||
| + | *[[Manuals/calci/SPELLINTEGER | SPELLINTEGER]] | ||
| + | *[[Manuals/calci/SPELLNUMBER | SPELLNUMBER]] | ||
| + | *[[Manuals/calci/SPELLTEENS | SPELLTEENS]] | ||
| + | *[[Manuals/calci/SPELLTENS | SPELLTENS]] | ||
| + | *[[Manuals/calci/STANDARDPHONETICCODES | STANDARDPHONETICCODES]] | ||
| + | *[[Manuals/calci/STRIKETHROUGH | STRIKETHROUGH]] | ||
| + | *[[Manuals/calci/STRINGTOARRAY | STRINGTOARRAY]] | ||
| + | *[[Manuals/calci/SUBSCRIPT | SUBSCRIPT]] | ||
| + | *[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]] | ||
| + | *[[Manuals/calci/SUBSTRINGCOUNT | SUBSTRINGCOUNT]] | ||
| + | *[[Manuals/calci/SUPERSCRIPT | SUPERSCRIPT]] | ||
| + | *[[Manuals/calci/TEXT | TEXT]] | ||
| + | *[[Manuals/calci/UNDERLINE | UNDERLINE]] | ||
| + | *[[Manuals/calci/UPPER | UPPER]] | ||
| + | *[[Manuals/calci/UPPERCASE | UPPERCASE]] | ||
| + | *[[Manuals/calci/VALUE | VALUE]] | ||
| + | *[[Manuals/calci/VALUEITSELF | VALUEITSELF]] | ||
| + | *[[Manuals/calci/VOID | VOID]] | ||
| + | *[[Manuals/calci/WRITE | WRITE]] | ||
| + | *[[Manuals/calci/WRITELN | WRITELN]] | ||
| + | *[[Manuals/calci/WS | WS]] | ||
Revision as of 14:35, 14 November 2016
LIST OF ALL FUNCTIONS
STATISTICAL FUNCTIONS1
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEBOTTOM
- AVERAGEIF
- AVERAGEMIDDLE
- AVERAGETOP
- AVG
- BETA
- BETWEEN
- BETWEENCORE
- BINOM
- BINOMIAL
- BINOMIALCOEFFICIENT
- CONFIDENCE
- COUNT
- COUNTA
- DECREASING
- DECREMENT
- DESCRIBENUMBER
- DESCRIPTIVESTATISTICS
- COUNTBLANK
- COUNTIF
- COVAR
- COVARIANCEDATAANALYSIS
- DET
- DEVSQ
- FEQ
- FINV
- FISHER
- FISHERINV
- FLOYDSTRIANGLE
- FREQUENCY
- FRIEDMANTEST
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAFUNCTION
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- HARMONICSERIES
- HYPGEOM
- HYPGEOMDIST
- KRONECKERPRODUCT
- KURT
- LAMDASELF
- LARGE
- LAST
- LIST
- LISTALL
- LOGINV
- MAX
- MAXA
- MAXIF
- MEAN
- MEDIAN
- MEDIANIF
- MEQUAL
- MIN
- MINA
- MINIF
- MINMAX
- MODE
- MODEIF
- MRSQ
- NEGBINOM
- NEGBINOMDIST
- PASCALTRIANGLE
- PEARSON
- PERCENT
- PERCENTAGES
- PERCENTILE
- PERCENTRANK
- PERFECTNUMBERS
- PERMUT
- PERMUTATIONS
- PROB
- QUARTILE
- QUATERNION
- RANK
- RANKANDPERCENTILE
- RANKS
- RATIOS
- RECIPROCAL
- RECIPROCALOF
- RSQ
- SMALL
- SMALLLETTERS
- STANDARDIZE
- STDEV
- STDEVA
- STDEVIF
- STDEVP
- STDEVPA
- STDEVPIF
- TDIST
- TINV
- TOP
- TOPN
- TOQUARTER
- TRIM
- TRIMARRAY
- TRIMMEAN
- VAR
- VARA
- VARIF
- VARP
- VARPA
- VARPIF
- VARS
- XBETWEEN
STATISTICAL FUNCTIONS2
- BERNOULLIDISTRIBUTED
- BETADIST
- BETADISTX
- BETAFUNCTION
- BETAINV
- BINOMDIST
- BINOMIALDISTRIBUTED
- BINOMIALPROBABILTY
- BINOMIALSERIES
- CHIDIST
- CHIINV
- CHITEST
- CORREL
- CORRELATIONDATAANALYSIS
- CRITBINOM
- DISCRETEDISTRIBUTED
- EXPONDIST
- EXPONENTIALSMOOTHING
- FDIST
- FORECAST
- GROWTH
- HISTOGRAM
- KFUNCTION
- KRUSKALWALLISTEST
- KSTESTCORE
- KSTESTEXPONENTIAL
- KSTESTNORMAL
- LEVENESTEST
- LEVENESTESTOLD
- LINEST
- LINKEDLIST
- LINKNODE
- LISPLIST
- LOGNORMDIST
- MANNWHITNEYUTEST
- MOODSMEDIANTEST
- MOVINGAVERAGE
- MPEARSON
- MULTIPLEREGRESSIONANALYSIS
- NORMALDISTRIBUTED
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PATTERNDISTRIBUTED
- POISSON
- POISSONDISTRIBUTED
- REGRESSIONANALYSIS
- REPEAT
- SAMPLING
- SIGNTEST
- SKEW
- SKEWSYMMETRIC
- STATIC
- STATS
- STEYX
- TREND
- TTEST
- TTESTPAIRED
- TTESTTWOSAMPLESEQUALVARIANCES
- TTESTTWOSAMPLESUNEQUALVARIANCES
- UNIFORMDISTRIBUTED
- WEIBULL
- WILCOXONSIGNEDRANKTEST
- ZTEST
- ZTESTTWOSAMPLEFORMEANS
MATH1
- ABS
- ACOS
- ACOSH
- ADD
- ADDBY
- ADDCLAUSE
- ADDFACT
- ADDWITH
- ANGLE
- ANGLEAT
- ANGLES
- ANGLESLIST
- ANTILOG
- ARITHMETICSERIES
- ASCENDING
- ASIN
- ASINH
- ATAN
- ATANH
- BASETHETA
- CAL
- CALC
- CALCULATE
- CAR
- CARTESIANPRODUCT
- CARTESIANPRODUCTWITHOUTFLATTEN
- CEILING
- CEILINGAT
- CIS
- COMBIN
- COMBINATIONS
- COMPLEMENT
- COS
- COSEC
- COSH
- COTAN
- COTH
- CROSSPRODUCT
- CSCH
- CUBEROOT
- CUBES
- CYCLEWITHIN
- DCOS
- DCOSEC
- DCOTAN
- DECIMAL
- DECIMALPART
- DEG
- DEGREES
- DEGREESLIST
- DESCENDING
- DIFFERENCE
- DIGITS
- DISTINCT
- DISTINCTSET
- DIVIDE
- DIVIDEBY
- DIVIDEWITH
- DIVISION
- DIVISIONOF
- DIVPARTS
- DOTPRODUCT
- DSEC
- DSIN
- DTAN
- DYADIC
- ELEMENTAT
- ELEMENTDIS
- ELEMENTINARRAY
- EQ
- EQS
- EQUATION
- EVEN
- EVENS
- EVENSET
- EVENSUPTO
- EVERYSET
- EXP
- EXPOF
- FACT
- FACTDOUBLE
- FACTORIAL
- FACTS
- FACTUNTIL
- FIBONACCI
- FIBONNACI
- FIFTHOF
- FLOOR
- FLOORAT
- FOURIERANALYSIS
- FOURTHOF
- FOURTHROOT
- FRACTION
- GCD
- GCV
- GE
- GEOMETRICSERIES
- GOLDENANGLE
- GOLDENRATIO
- GREEK
- GREEKARRAY
- GREEKS
- GT
- GTE
- HALFOF
- HUNDRED
- INCREASING
- INCREMENT
- INSET
- INT
- INTDIV
- INTEGERDIVISION
- INTEGERS
- INTERSECTION
- ITHPRIME
- JOIN
- JOINSET
- JPARTITION
- LB
- LBSTAR
- LCM
- LE
- LGSTAR
- LINEAREQUATION
- LISTPRIMES
- LN
- LNSTAR
- LOG
- LOGSTAR
- LOGVALUES
- LT
- LTE
- LUCAS
- MAKEPAIR
- MAKESUBTOTAL
- MAKEUNITVALUE
- MAKEFRACTION
- MINUS
- MINUSOF
- MOD
- MODBY
- MODWITH
- MOP
- MOPWITH
- MOPWITHEQ
- MOPWITHFEQ
- MOPWITHGT
- MOPWITHGTE
- MOPWITHLT
- MOPWITHLTE
- MOPWITHMOD
- MOPWITHNE
- MOPWITHPOWER
- MOPX
- MROUND
- MULTINOMIAL
- MULTIPLES
- MULTIPLESOF
- MULTIPLESTWO
- MULTIPLY
- MULTIPLYBY
- MULTIPLYWITH
- NEG
- NEGATE
- NEGATIVE
- NEXTPOWER
- NTH
- NTHELEMENT
- NTHROOT
- NUMS
- NUMSCORE
- ODD
- ODDS
- ODDSET
- ODDSUPTO
- ORDINAL
- PLUSMINUS
- POSITIVE
- POWER
- PRIMEFACTORS
- PRIMES
- PRODUCT
- PRODUCTOF
- QUADRATIC
- QUOTIENT
- RAD
- RADIANSLIST
- RAND
- RANDBETWEEN
- RANDINT
- RANDNUM
- REM
- REMAINDER
- ROMAN
- ROMANOLD
- ROOTNTH
- ROOTNTHFUNCTION
- ROOTTHETA
- ROOTTHETATOQUARDRANT
- ROUND
- ROUNDAT
- ROUNDDOWN
- ROUNDUP
- SCALARPRODUCT
- SEC
- SECH
- SERIES
- SERIESOF
- SERIESSTR
- SERIESSUM
- SERIESTERMS
- SET
- SETCONVERSION
- SETVALUE
- SEVENTHOF
- SEVERAL
- SIGMA
- SIGMAOF
- SIGN
- SIN
- SINC
- SINCP
- SINH
- SIXTHOF
- SLOG
- SORTING
- SQRT
- SQRTPI
- SUBSET
- SUBTOTAL
- SUBTRACT
- SUBTRACTBY
- SUBTRACTFROM
- SUBTRACTWITH
- SUM
- SUMBY
- SUMFACTORS
- SUMIF
- SUMOF
- SUMOFSQUARES
- SUMPRODUCT
- SUPERLOGARITHM
- SUPERSET
- TAN
- TANH
- TEN
- TENTHOF
- THETAINDEGREES
- THETAS
- THIRDOF
- THOUSAND
- TRILLION
- TRUNC
- UNION
- UNIQUE
- UNIQUESET
- UNIQUESUBSTRINGS
- UNITADD
- UNITDIVIDE
- UNITEQ
- UNITEQS
- UNITEXPRESSION
- UNITGE
- UNITGT
- UNITIFY
- UNITLE
- UNITLT
- UNITMINUS
- UNITMOD
- UNITMULTIPLY
- UNITNE
- UNITNES
- UNITOP
- UNITPOWER
- VECTORDIRECTPRODUCT
- VECTORPRODUCT
MATH2
- ACKERMANN
- ADDINS
- ARITHMETICSERIESCORE
- CREATEEQUATION
- CREATEFORMULA
- DELTA
- DERIVATIVEOFFUNCTION
- ENFORCEINTEGER
- ENFORCENATURAL
- ENFORCENEGATIVE
- ENFORCENEGATIVEINTEGER
- ENFORCENEGZEROPOS
- ENFORCEPOSITIVE
- ENFORCEPOSITIVEINTEGER
- ENFORCETYPE
- ENFORCEZERO
- EVALX
- FLATTEN
- INTEGRATE
- INTEGRATEFOR
- INTEGRATEFORCORE
- INTEGRATEUNTIL
- INTS
- INTSTWO
- NEWCALCI
- NEWFUNCTIONNAME
- QUALITATIVEDESCRIPTION
- SUMSQ
- SUMWITH
- TETRATE
DATE AND TIME1
- ADDDATE
- CLOCK
- CALENDER
- DATE
- DATESERIAL
- DATESTRING
- DATETOEXCEL
- DATETOJS
- DATEVALUE
- DAY
- DAYINDEX
- DAYS
- DAYSBETWEEN
- DAYSBETWEENBASIS
- DAYSINYEAR
- DAYSINYEARTILLDATE
- EDATE
- EOMONTH
- FORMATTIME
- FROMTO
- FROMTOADV
- GREGORIANDATE
- HOUR
- JULIANDATE
- MINUTE
- MONTH
- MONTHEND
- MONTHENDLEAP
- MONTHS
- MONTHSTRING
- NETWORKDAYS
- SECOND
- TIME
- TODATE
- TODAY
- TOMONTH
- TONUMBER
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARBASIS
- YEARFRAC
DATE AND TIME2
ENGINEERING1
- ARGS
- ARGSONE
- COMPLEX
- COMPLEXNUM
- COMPLEXNUMBER
- CONVERT
- CONVERTCORE
- ERF
- ERFC
- ERROR
- ERRORTYPE
- ERRORTYPES
- GESTEP
- GFUNCTION
- HEX
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMCOSH
- IMCOT
- IMCOTH
- IMCSC
- IMCSCH
- IMDIV
- IMDIVTWO
- IMEXP
- IMLN
- IMLOG
- IMPOWER
- IMPRODUCT
- IMPRODUCTTWO
- IMREAL
- IMSEC
- IMSECH
- IMSIN
- IMSINH
- IMSQRT
- IMSTRING
- IMSUB
- IMSUBTWO
- IMSUM
- IMSUMTWO
- IMTAN
- IMTANH
- MAKECOMPLEXIMINUS
- MAKECOMPLEXIMINUSSIMPLE
- MAKECOMPLEXIPLUS
- MAKECOMPLEXISIMPLE
- REMOVECONVERSION
- REMOVENUMBERS
- TOUNITS
- UNITS
- UNITSFAILTONULL
- UNITSOF
ENGINEERING2
FINANCIAL1:
* DISC
- DOLLAR
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- EFFECTBULGE
- EURO
- EUROCONVERT
- FV
- FVIF
- FVIFA
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- LOGEST
- MDURATION
- MIRR
- NPER
- NPV
- PMT
- PMTLISTING
- PPMT
- PV
- PVEQUATION
- PVIF
- PVIFA
- RATE
- RECEIVED
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- USDOLLAR
- XNPV
FINANCIAL2:
* PRICEDISC
GEOMETRY AND GRAPH1:
- BARCHART
- BARHIERARCHY
- CHORDDIAGRAM
- CHORDMATRIXDIAGRAM
- CIRCLE
- CIRCLEPACKING
- CIRCLEWITHTEXT
- CUBE
- CUBEDEV
- CURVE
- DRAW
- DRAWDATACURVE
- DRAWSHAPE
- EDGEBUNDLING
- ELLIPSE
- FROMTOGEOMETRIC
- FRACTAL
- GEOMETRY
- GRAPH
- HYPOTENUSE
- INQUADRANT
- INQUADRANTSIGN
- INQUADRANTTHETA
- INTERCEPT
- LINE
- LISSAJOUS
- LISSAJOUSCURVE
- MAKEZCIRCLE
- MANDELBROT
- PIECHART
- PLOT
- POINT
- POINTAT
- POLYGON
- RECTANGLE
- SHAPE
- SLOPE
- SOR
- SORT
- SPHERE
- SQUARES
- STAR
- STARS
- TETRA
- TETRAHEDRON
- TETRAHEDRONDEV
- TRIANGLE
- XYPOINT
GEOMETRY AND GRAPH2:
- BUBBLECHART
- CLOSEDCURVE
- CLUSTERDENDROGRAM
- DRAGON
- FD
- FDZ
- filegeometry
- PLOTDEV
- STEMANDLEAFPLOT
- SURFACEGRAPH
- SURFACEGRAPHCORE
- TORUS
INFORMATION1:
- APPLY
- APPLYFUNCTIONTOALLELEMENTS
- APPLYFUNCTIONTOELEMENTS
- APPLYFUNCTIONTORANGE
- APPLYOF
- APPLYTOALLKEYS
- APPLYTOKEYS
- ATOZ
- BADWORDS
- BG
- BILLION
- BOLD
- BOTTOM
- BOTTOMN
- CALENDARPLOT
- CAPITALLETTERS
- CELL
- COMMENTGET
- COMPARE
- CONS
- CONST
- CONSTANTS
- DE
- DECLARE
- DECR
- EXEC
- FORMATRANGE
- FORMATWITHRANGES
- GDIM
- GOALSEEK
- GOTO
- GOV
- HEART
- HREF
- HTML
- HYPERLINK
- IN
- INARRAY
- INCR
- ISARRAY
- ISARRAYORSUCH
- ISARRAYORSUCHNOTSTRING
- ISATOMICSYMBOL
- ISBLANK
- ISBOOLEAN
- ISCOMPLEX
- ISELEMENTLIKECOMPLEX
- ISEMPTY
- ISEQUATION
- ISERR
- ISERROR
- ISEVEN
- ISFUNCTION
- ISFUNCTIONSYMBOL
- ISIGNOREINDEX
- ISINARRAY
- ISLAMBDAEQUATION
- ISLEAPYEAR
- ISLIKELYTYPE
- ISLOCATION
- ISLOGICAL
- ISLOWER
- ISMONTH
- ISNA
- ISNONTEXT
- ISNULL
- ISNULLLIKE
- ISNUMBER
- ISNUMBERSYMBOLS
- ISOBJECT
- ISODD
- ISOPERATORSYMBOL
- ISPERFECTNUMBER
- ISPOINTLIKE
- ISPRIME
- ISRANGEOBJECT
- ISREF
- ISREGEXP
- ISSAME
- ISSTRING
- ISSUBSET
- ISSUPERSET
- ISTEXT
- ISVECTOR
- ISVECTORSIZE
- ITALIC
- JIS
- KEYINARRAY
- KEYS
- KEYTAGS
- KNOW
- LAZYOBJECT
- LAZYRANGE
- LAZYSERIES
- LIKE
- LOAD
- LOADSEMANTICINFO
- LOL
- MAP
- MAPLISP
- MAPTABLE
- MATCH
- MILLION
- MROWAGGREGATE
- MROWDUPLICATE
- MROWOP
- NA
- NE
- NES
- NEST
- NIL
- NINTHOF
- NO
- NODE
- NODES
- NODESX
- NODET
- NODEX
- NONAME
- NONE
- NUMERICARRAY
- OBJ
- OBJECT
- OFF
- OFFSET
- OK
- OLDX
- ON
- OPF
- OPFSTR
- PFX
- PIGEN
- PIVOT
- RADIALTREE
- SQL
- SYMBOLFILTER
- SYMBOLIC
- SYMBOLNUMBER
- TABLE
- TABLEADDROW
- TABLEARRAY
- TABLES
- TABULATE
- TABULATEFORPIVOT
- TAGS
- THING
- THINK
- TRUTHY
- UNDERSTAND
- UNDERSTANDSTRING
- UNESCAPE
- UNICODESYMBOL
- UNK
- UNKNOWN
- UNQUOTE
- XDY
- XML
- XMLCALL
- YES
- YUP
INFORMATION2:
- ACRONYM
- APOLOGIZE
- BAHTTEXT
- BYID
- CALLLISP
- CALLOPTION
- CALLSQL
- CANVASIMAGE
- COALESCE
- CONTAINS
- CONTAINVISUALLY
- EXPORTTO
- EXPRESSMYOPINION
- EXPRESSUSERSOPINION
- MODEL
- OCCURANCES
- PARTITIONP
- PARTITIONTREE
- PARTP
- PFX
- READFROMLZWIMAGE
- SDIM
- SOSZ
* SOT
* SOW
- SOWH
- SOZ
- TOSIMPLEARRAY
- TRIGGEREVENT
- TSV
- TTYL
- URLEXPAND
- URLFRAMEEXPAND
- URLLIST
- URLOBJECT
- URLS
- WHOISUSER
- XFUNCTIONAT
- XMLDEPTH
* XMLSET
LOGICAL1:
* BITAND
- BITLSHIFT
- BITNOT
- BITOR
- BITRSHIFT
- BITRSHIFTZ
- BITXOR
- FALSE
- FALSEVALUE
- FALSEY
- IF
- IFNULL
- NOT
- NOTOK
- OR
- TRUE
- TRUEVALUE
DATABASE AND LIST MANAGEMENT1:
DATABASE AND LIST MANAGEMENT2:
LOOKUP AND REFERENCE1:
- ADDRESS
- AGE
- AREAS
- BEEP
- CHOOSE
- COLORS
- COLUMN
- COLUMNS
- COLUMNWITH
- COLWITH
- DONOTHING
- DOSQL
- DROP
- DUPLICATE
- FIELDINDEX
- FILTER
- FORMULA
- FORRESULTSONLY
- FUCTIONTOIMPLEMENT
- FUNC
FUNCT - * FUNCT FUNCTIONFROMTEMPLATE - * FUNCTIONFROMTEMPLATE FUNCTION OF - * FUNCTIONOF FUZZY - * FUZZY GETCOLUMN - * GETCOLUMN GETCONVERSION - * GETCONVERSION GETFUNCTION - * GETFUNCTION GETFUNCTION SET - * GETFUNCTIONSET GET GPS -* GETGPS GETJSON - * GETJSON GET LINE- * GETLINE GET NUMBER TAIL - * GETNUMBERTAIL GET REAL OR COMPLEX - * GETREALORCOMPLEX GET ROW - * GETROW GET SERIES - * GETSERIES GMAP - * GMAP GOALSEEK - * GOALSEEK GROUP - * GROUP HLOOKUP - * HLOOKUP HVLOOKUP - * HVLOOKUP INDEX - * INDEX INDIRECT - * INDIRECT INFO - * INFO INTEG - * INTEG LIST COLUMN LABELS - * LISTCOLUMNLABELS LIST COLUMNS - * LISTCOLUMNS LIST ROWS - * LISTROWS LIST UNIQUE - * LISTUNIQUE LISTV - * LISTV LOOKUP - * LOOKUP LOOP MEDIA - * LOOPMEDIA MLANGUAGE LOOKUP - * MLANGUAGELOOKUP NUMBER EIGHT - * NUMBEREIGHT NUMBER FIVE - * NUMBERFIVE NUMBER FOUR - * NUMBERFOUR NUMBER NINE - * NUMBERNINE NUMBER ONE - * NUMBERONE NUMBER SEVEN - * NUMBERSEVEN NUMBER SIX - * NUMBERSIX NUMBER TEN - * NUMBERTEN NUMBER THREE - * NUMBERTHREE NUMBER TWO - * NUMBERTWO NUMBER ZERO - * NUMBERZERO ONE - * ONE ONE BY -* ONEBY PARSE - * PARSE PARSE LISP - * PARSELISP PARSE NUMBER - * PARSENUMBER PARSE SQL - * PARSESQL PARSESTRING WITHOUT PARANTHESIS - * PARSESTRINGWITHOUTPARANTHESIS PASTE COLUMNS - * PASTECOLUMNS PASTE ROWS - * PASTEROWS PAUSE - * PAUSE QUOTE - * QUOTE ROW - * ROW ROWS - * ROWS ROW WITH - * ROWWITH SMILE - * SMILE UNDEFINED - * UNDEFINED UPTO - * UPTO VLOOKUP - * VLOOKUP
Lookup and Reference2:
ANALYZE - * ANALYZE
ASSIGN- * ASSIGN
ASYNC ITERATE* ASYNCITERATE
ATTRTOPROP - * ATTRTOPROP
CASE - * CASE
CASEIF - * CASEIF
CDR - * CDR
EFFECT COLORBOOK - * EFFECTCOLORBOOK
EFFECTEDGEDETECTION - * EFFECTEDGEDETECTION
EFFECTEDGEDETECTIONALGORITHM - * EFFECTEDGEDETECTIONALGORITHM
EFFECTGLASS - * EFFECTGLASS
EFFECTGLASSBOX - * EFFECTGLASSBOX
EFFECT GLASS PATTERN -* EFFECTGLASSPATTERN
EFFECTNEONLINES - * EFFECTNEONLINES
EFFECTPATTERN - * EFFECTPATTERN
EFFECTRIPPLES - * EFFECTRIPPLES
GETCELLTD- * GETCELLTD
GETLATLONG - * GETLATLONG
GKMAPPING - * GKMAPPING
PENTATE - * PENTATE
QPIVOT - * QPIVOT
QPIVOT IN CUBE - * QPIVOTINCUBE
SAFE EVAL - * SAFEEVAL
STEP LOOP - * STEPLOOP
TIMER - * TIMER
TIMES - * TIMES
TIME STRING - * TIMESTRING
TYPE - * TYPE
TZ - * TZ
XLBETWEEN - * XLBETWEEN
XLR BETWEEN - * XLRBETWEEN
XPY - * XPY
XR BETWEEN - * XRBETWEEN
XSY - * XSY
Text and Data1: BADWORDS - * BADWORDS CHAR - * CHAR CHR-* CHR CLAUSES - * CLAUSES CLEAN - * CLEAN CLEAR - * CLEAR CLS -* CLS CODE - * CODE DEFAULT - * DEFAULT DEFAULT NUMBER - * DEFAULTNUMBER DEFAULT PROPER - * DEFAULTPROPER DEFUN - * DEFUN DES - * DES DESCRIBEFUNCTIONCALLMISSING - * DESCRIBEFUNCTIONCALLMISSING DEVARRAY - * DEVARRAY DIM - * DIM DIMENSIONS - * DIMENSIONS DIS - * DIS EIGHTHOF - * EIGHTHOF ESCAPE - * ESCAPE EXTRACT NUMBERS - * EXTRACTNUMBERS EXTRACT TEXT - * EXTRACTTEXT FAIL - * FAIL FIND - * FIND FINDB - * FINDB FINDUNIT - * FINDUNIT FIXCHARS - * FIXCHARS FIXED - * FIXED FIXED BAD- * FIXEDBAD FOR - * FOR FOR ALL- * FORALL FOREACH - * FOREACH FORLOOP - * FORLOOP LEFTB - * LEFTB LEN - * LEN LENB - * LENB LETTERS - * LETTERS LOWER - * LOWER LOWER CASE - * LOWERCASE LZ - * LZ LZWCOMPRESS - * LZWCOMPRESS LZWDECOMPRESS - * LZWDECOMPRESS MID - * MID MIDB - * MIDB MIDDLE - * MIDDLE MIDN - * MIDN MIXED CASE - * MIXEDCASE NOK - * NOK NON FALSE VALUE - * NONFALSEVALUE NON NEGATIVE - * NONNEGATIVE NON POSITIVE - * NONPOSITIVE NON ZERO - * NONZERO NON ZERO VALUE - * NONZEROVALUE NOPE - * NOPE NOW - * NOW NULL - * NULL NULL IF - * NULLIF NUM - * NUM NUMBER - * NUMBER NVL - * NVL OSTYLE - * OSTYLE OUTPUT - * OUTPUT PACK - * PACK PADZEROES - * PADZEROES PHONETIC - * PHONETIC PHONETIC CODES - * PHONETICCODES PRINT - * PRINT PRINT CONVERSION - * PRINTCONVERSION PRINTTAGS - * PRINTTAGS PRINT UNIT TAGS - * PRINTUNITTAGS PRINT WITH UNITS - * PRINTWITHUNITS PROPER - * PROPER PUSH - * PUSH REMOVE TEXT - * REMOVETEXT REPEAT CHAR - * REPEATCHAR REPLACE - * REPLACE REPLACE ARRAY - * REPLACEARRAY REPLACEB - * REPLACEB REPLACE BAD - * REPLACEBAD REPT - * REPT REVERSE - * REVERSE RIGHTB - * RIGHTB RTD - * RTD SEARCH - * SEARCH SEARCHB - * SEARCHB SEARCH BOX SPACE - * SearchBoxSpace SEQ - * SEQ SET VALUE STRING - * SETVALUESTRING SET WHOISUSER - * SETWHOISUSER SLIDER CONTROL - * SLIDERCONTROL SO - * SO SOB - * SOB SOC - * SOC SOH - * SOH SOI - * SOI SOL - * SOL SOLT - * SOLT SOLTWH - * SOLTWH