Difference between revisions of "Template:Calc functions"

:[[Documentation/How_Tos/Calc: FREQUENCY function|FREQUENCY]], [[Documentation/How_Tos/Calc: GROWTH function|GROWTH]], [[Documentation/How_Tos/Calc: LINEST function|LINEST]], [[Documentation/How_Tos/Calc: LOGEST function|LOGEST]], [[Documentation/How_Tos/Calc: MDETERM function|MDETERM]], [[Documentation/How_Tos/Calc: MINVERSE function|MINVERSE]], [[Documentation/How_Tos/Calc: MMULT function|MMULT]], [[Documentation/How_Tos/Calc: MUNIT function|MUNIT]], [[Documentation/How_Tos/Calc: SUMPRODUCT function|SUMPRODUCT]], [[Documentation/How_Tos/Calc: SUMX2MY2 function|SUMX2MY2]], [[Documentation/How_Tos/Calc: SUMX2PY2 function|SUMX2PY2]], [[Documentation/How_Tos/Calc: SUMXMY2 function|SUMXMY2]], [[Documentation/How_Tos/Calc: TRANSPOSE function|TRANSPOSE]], [[Documentation/How_Tos/Calc: TREND function|TREND]]  

: The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.

:[[Documentation/How_Tos/Calc: COMPLEX function|COMPLEX]], [[Documentation/How_Tos/Calc: IMABS function|IMABS]], [[Documentation/How_Tos/Calc: IMAGINARY function|IMAGINARY]], [[Documentation/How_Tos/Calc: IMPOWER function|IMPOWER]], [[Documentation/How_Tos/Calc: IMARGUMENT function|IMARGUMENT]], [[Documentation/How_Tos/Calc: IMCOS function|IMCOS]], [[Documentation/How_Tos/Calc: IMDIV function|IMDIV]], [[Documentation/How_Tos/Calc: IMEXP function|IMEXP]], [[Documentation/How_Tos/Calc: IMCONJUGATE function|IMCONJUGATE]], [[Documentation/How_Tos/Calc: IMLN function|IMLN]], [[Documentation/How_Tos/Calc: IMLOG10 function|IMLOG10]], [[Documentation/How_Tos/Calc: IMLOG2 function|IMLOG2]], [[Documentation/How_Tos/Calc: IMPRODUCT function|IMPRODUCT]], [[Documentation/How_Tos/Calc: IMREAL function|IMREAL]], [[Documentation/How_Tos/Calc: IMSIN function|IMSIN]], [[Documentation/How_Tos/Calc: IMSUB function|IMSUB]], [[Documentation/How_Tos/Calc: IMSUM function|IMSUM]], [[Documentation/How_Tos/Calc: IMSQRT function|IMSQRT]]

:[[Documentation/How_Tos/Calc: DCOUNT function|DCOUNT]], [[Documentation/How_Tos/Calc: DCOUNTA function|DCOUNTA]], [[Documentation/How_Tos/Calc: DGET function|DGET]], [[Documentation/How_Tos/Calc: DMAX function|DMAX]], [[Documentation/How_Tos/Calc: DMIN function|DMIN]], [[Documentation/How_Tos/Calc: DAVERAGE function|DAVERAGE]], [[Documentation/How_Tos/Calc: DPRODUCT function|DPRODUCT]], [[Documentation/How_Tos/Calc: DSTDEV function|DSTDEV]], [[Documentation/How_Tos/Calc: DSTDEVP function|DSTDEVP]], [[Documentation/How_Tos/Calc: DSUM function|DSUM]], [[Documentation/How_Tos/Calc: DVAR function|DVAR]], [[Documentation/How_Tos/Calc: DVARP function|DVARP]]

:[[Documentation/How_Tos/Calc: TODAY  function|TODAY]], [[Documentation/How_Tos/Calc: NOW function|NOW]], [[Documentation/How_Tos/Calc: YEAR function|YEAR]], [[Documentation/How_Tos/Calc: MONTH function|MONTH]], [[Documentation/How_Tos/Calc: DAY function|DAY]], [[Documentation/How_Tos/Calc: WEEKDAY function|WEEKDAY]], [[Documentation/How_Tos/Calc: HOUR function|HOUR]], [[Documentation/How_Tos/Calc: MINUTE function|MINUTE]], [[Documentation/How_Tos/Calc: SECOND function|SECOND]], [[Documentation/How_Tos/Calc: DATE function|DATE]], [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]], [[Documentation/How_Tos/Calc: TIME function|TIME]], [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]], [[Documentation/How_Tos/Calc: EOMONTH function|EOMONTH]], [[Documentation/How_Tos/Calc: EDATE function|EDATE]], [[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]], [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]], [[Documentation/How_Tos/Calc: DAYS function|DAYS]], [[Documentation/How_Tos/Calc: DAYS360 function|DAYS360]], [[Documentation/How_Tos/Calc: DAYSINMONTH function|DAYSINMONTH]], [[Documentation/How_Tos/Calc: DAYSINYEAR function|DAYSINYEAR]], [[Documentation/How_Tos/Calc: WEEKS function|WEEKS]], [[Documentation/How_Tos/Calc: WEEKSINYEAR function|WEEKSINYEAR]], [[Documentation/How_Tos/Calc: WEEKNUM function|WEEKNUM]], [[Documentation/How_Tos/Calc: WEEKNUM_ADD function|WEEKNUM_ADD]], [[Documentation/How_Tos/Calc: MONTHS function|MONTHS]], [[Documentation/How_Tos/Calc: YEARS function|YEARS]], [[Documentation/How_Tos/Calc: ISLEAPYEAR function|ISLEAPYEAR]], [[Documentation/How_Tos/Calc: EASTERSUNDAY function|EASTERSUNDAY]], [[Documentation/How_Tos/Calc: YEARFRAC function|YEARFRAC]]

:<b>&middot; </b>[[Documentation/How_Tos/Calc: CUMIPMT function|CUMIPMT]], [[Documentation/How_Tos/Calc: CUMIPMT_ADD function|CUMIPMT_ADD]], [[Documentation/How_Tos/Calc: CUMPRINC function|CUMPRINC]], [[Documentation/How_Tos/Calc: CUMPRINC_ADD function|CUMPRINC_ADD]], [[Documentation/How_Tos/Calc: EFFECTIVE function|EFFECTIVE]], [[Documentation/How_Tos/Calc: EFFECT_ADD function|EFFECT_ADD]], [[Documentation/How_Tos/Calc: FV function|FV]], [[Documentation/How_Tos/Calc: FVSCHEDULE function|FVSCHEDULE]], [[Documentation/How_Tos/Calc: IPMT function|IPMT]], [[Documentation/How_Tos/Calc: IRR function|IRR]], [[Documentation/How_Tos/Calc: ISPMT function|ISPMT]], [[Documentation/How_Tos/Calc: MIRR function|MIRR]], [[Documentation/How_Tos/Calc: NPER function|NPER]], [[Documentation/How_Tos/Calc: NPV function|NPV]], [[Documentation/How_Tos/Calc: PMT function|PMT]], [[Documentation/How_Tos/Calc: PPMT function|PPMT]], [[Documentation/How_Tos/Calc: PV function|PV]], [[Documentation/How_Tos/Calc: RATE function|RATE]], [[Documentation/How_Tos/Calc: RRI function|RRI]], [[Documentation/How_Tos/Calc: XIRR function|XIRR]], [[Documentation/How_Tos/Calc: XNPV function|XNPV]]

:<b>&middot; </b>[[Documentation/How_Tos/Calc: ACCRINT function|ACCRINT]], [[Documentation/How_Tos/Calc: ACCRINTM function|ACCRINTM]], [[Documentation/How_Tos/Calc: DISC function|DISC]], [[Documentation/How_Tos/Calc: DURATION function|DURATION]], [[Documentation/How_Tos/Calc: DURATION_ADD function|DURATION_ADD]], [[Documentation/How_Tos/Calc: INTRATE function|INTRATE]], [[Documentation/How_Tos/Calc: MDURATION function|MDURATION]], [[Documentation/How_Tos/Calc: NOMINAL function|NOMINAL]], [[Documentation/How_Tos/Calc: NOMINAL_ADD function|NOMINAL_ADD]], [[Documentation/How_Tos/Calc: ODDFPRICE function|ODDFPRICE]], [[Documentation/How_Tos/Calc: ODDFYIELD function|ODDFYIELD]], [[Documentation/How_Tos/Calc: ODDLPRICE function|ODDLPRICE]], [[Documentation/How_Tos/Calc: ODDLYIELD function|ODDLYIELD]], [[Documentation/How_Tos/Calc: PRICE function|PRICE]], [[Documentation/How_Tos/Calc: PRICEDISC function|PRICEDISC]], [[Documentation/How_Tos/Calc: PRICEMAT function|PRICEMAT]], [[Documentation/How_Tos/Calc: RECEIVED function|RECEIVED]], [[Documentation/How_Tos/Calc: TBILLEQ function|TBILLEQ]], [[Documentation/How_Tos/Calc: TBILLPRICE function|TBILLPRICE]], [[Documentation/How_Tos/Calc: TBILLYIELD function|TBILLYIELD]], [[Documentation/How_Tos/Calc: YIELD function|YIELD]], [[Documentation/How_Tos/Calc: YIELDDISC function|YIELDDISC]], [[Documentation/How_Tos/Calc: YIELDMAT function|YIELDMAT]]

:[[Documentation/How_Tos/Calc: CELL function|CELL]], [[Documentation/How_Tos/Calc: CURRENT function|CURRENT]], [[Documentation/How_Tos/Calc: FORMULA function|FORMULA]], [[Documentation/How_Tos/Calc: ISBLANK function|ISBLANK]], [[Documentation/How_Tos/Calc: ISERR function|ISERR]], [[Documentation/How_Tos/Calc: ISERROR function|ISERROR]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISEVEN_ADD function|ISEVEN_ADD]], [[Documentation/How_Tos/Calc: ISFORMULA function|ISFORMULA]], [[Documentation/How_Tos/Calc: ISLOGICAL function|ISLOGICAL]], [[Documentation/How_Tos/Calc: ISNA function|ISNA]], [[Documentation/How_Tos/Calc: ISNONTEXT function|ISNONTEXT]], [[Documentation/How_Tos/Calc: ISNUMBER function|ISNUMBER]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: ISODD_ADD function|ISODD_ADD]], [[Documentation/How_Tos/Calc: ISREF function|ISREF]], [[Documentation/How_Tos/Calc: ISTEXT function|ISTEXT]], [[Documentation/How_Tos/Calc: N function|N]], [[Documentation/How_Tos/Calc: NA function|NA]], [[Documentation/How_Tos/Calc: TYPE function|TYPE]]  

:[[Documentation/How_Tos/Calc: AND function|AND]], [[Documentation/How_Tos/Calc: FALSE function|FALSE]], [[Documentation/How_Tos/Calc: IF function|IF]], [[Documentation/How_Tos/Calc: NOT function|NOT]], [[Documentation/How_Tos/Calc: OR function|OR]], [[Documentation/How_Tos/Calc: TRUE function|TRUE]]

:<b>&middot; </b>[[Documentation/How_Tos/Calc: COSH function|COSH]], [[Documentation/How_Tos/Calc: SINH function|SINH]], [[Documentation/How_Tos/Calc: TANH function|TANH]], [[Documentation/How_Tos/Calc: COTH function|COTH]], [[Documentation/How_Tos/Calc: ACOSH function|ACOSH]], [[Documentation/How_Tos/Calc: ACOTH function|ACOTH]], [[Documentation/How_Tos/Calc: ASINH function|ASINH]], [[Documentation/How_Tos/Calc: ATANH function|ATANH]]  

:[[Documentation/How_Tos/Calc: BIN2DEC function|BIN2DEC]], [[Documentation/How_Tos/Calc: BIN2HEX function|BIN2HEX]], [[Documentation/How_Tos/Calc: BIN2OCT function|BIN2OCT]], [[Documentation/How_Tos/Calc: DEC2BIN function|DEC2BIN]], [[Documentation/How_Tos/Calc: DEC2HEX function|DEC2HEX]], [[Documentation/How_Tos/Calc: DEC2OCT function|DEC2OCT]], [[Documentation/How_Tos/Calc: HEX2BIN function|HEX2BIN]], [[Documentation/How_Tos/Calc: HEX2DEC function|HEX2DEC]], [[Documentation/How_Tos/Calc: HEX2OCT function|HEX2OCT]], [[Documentation/How_Tos/Calc: OCT2BIN function|OCT2BIN]], [[Documentation/How_Tos/Calc: OCT2DEC function|OCT2DEC]], [[Documentation/How_Tos/Calc: OCT2HEX function|OCT2HEX]]

:[[Documentation/How_Tos/Calc: ARABIC function|ARABIC]], [[Documentation/How_Tos/Calc: BAHTTEXT function|BAHTTEXT]], [[Documentation/How_Tos/Calc: DECIMAL function|DECIMAL]], [[Documentation/How_Tos/Calc: ROMAN function|ROMAN]]

:<b>&middot; </b>[[Documentation/How_Tos/Calc: B function|B]], [[Documentation/How_Tos/Calc: BETADIST function|BETADIST]], [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]], [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]], [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]], [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]], [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]], [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]], [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]], [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]], [[Documentation/How_Tos/Calc: FINV function|FINV]], [[Documentation/How_Tos/Calc: FISHER function|FISHER]], [[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]], [[Documentation/How_Tos/Calc: FDIST function|FDIST]], [[Documentation/How_Tos/Calc: FTEST function|FTEST]], [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]], [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]], [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]], [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]], [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]], [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]], [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]], [[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]], [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]], [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]], [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]], [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]], [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]], [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]], [[Documentation/How_Tos/Calc: PHI function|PHI]], [[Documentation/How_Tos/Calc: POISSON function|POISSON]], [[Documentation/How_Tos/Calc: PROB function|PROB]], [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]], [[Documentation/How_Tos/Calc: TDIST function|TDIST]], [[Documentation/How_Tos/Calc: TINV function|TINV]], [[Documentation/How_Tos/Calc: TTEST function|TTEST]], [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]], [[Documentation/How_Tos/Calc: ZTEST function|ZTEST]]

:[[Documentation/How_Tos/Calc: BASE function|BASE]], [[Documentation/How_Tos/Calc: CHAR function|CHAR]], [[Documentation/How_Tos/Calc: CLEAN function|CLEAN]], [[Documentation/How_Tos/Calc: CODE function|CODE]], [[Documentation/How_Tos/Calc: CONCATENATE function|CONCATENATE]], [[Documentation/How_Tos/Calc: DOLLAR function|DOLLAR]], [[Documentation/How_Tos/Calc: EXACT function|EXACT]], [[Documentation/How_Tos/Calc: FIND function|FIND]], [[Documentation/How_Tos/Calc: FIXED function|FIXED]], [[Documentation/How_Tos/Calc: LEFT function|LEFT]], [[Documentation/How_Tos/Calc: LEN function|LEN]], [[Documentation/How_Tos/Calc: LOWER function|LOWER]], [[Documentation/How_Tos/Calc: MID function|MID]], [[Documentation/How_Tos/Calc: PROPER function|PROPER]], [[Documentation/How_Tos/Calc: REPLACE function|REPLACE]], [[Documentation/How_Tos/Calc: REPT function|REPT]], [[Documentation/How_Tos/Calc: RIGHT function|RIGHT]], [[Documentation/How_Tos/Calc: SEARCH function|SEARCH]], [[Documentation/How_Tos/Calc: SUBSTITUTE function|SUBSTITUTE]], [[Documentation/How_Tos/Calc: T function|T]], [[Documentation/How_Tos/Calc: TEXT function|TEXT]], [[Documentation/How_Tos/Calc: TRIM function|TRIM]], [[Documentation/How_Tos/Calc: UPPER function|UPPER]], [[Documentation/How_Tos/Calc: VALUE function|VALUE]]

 

 

 

[[Category:Documentation]]