Difference between revisions of "Template:Calc functions"

These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet. The aim is for descriptions to be more precise, complete and consistent than before.

:[[Documentation/How_Tos/Calc: ACCRINT function|ACCRINT]], [[Documentation/How_Tos/Calc: ACCRINTM function|ACCRINTM]], [[Documentation/How_Tos/Calc: AMORDEGRC function|AMORDEGRC]], [[Documentation/How_Tos/Calc: AMORLINC function|AMORLINC]], [[Documentation/How_Tos/Calc: COUPDAYBS function|COUPDAYBS]], [[Documentation/How_Tos/Calc: COUPDAYS function|COUPDAYS]], [[Documentation/How_Tos/Calc: COUPDAYSNC function|COUPDAYSNC]], [[Documentation/How_Tos/Calc: COUPNCD function|COUPNCD]], [[Documentation/How_Tos/Calc: COUPNUM function|COUPNUM]], [[Documentation/How_Tos/Calc: COUPPCD function|COUPPCD]], [[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: DB function|DB]], [[Documentation/How_Tos/Calc: DDB function|DDB]], [[Documentation/How_Tos/Calc: DISC function|DISC]], [[Documentation/How_Tos/Calc: DOLLARDE function|DOLLARDE]], [[Documentation/How_Tos/Calc: DOLLARFR function|DOLLARFR]], [[Documentation/How_Tos/Calc: DURATION function|DURATION]], [[Documentation/How_Tos/Calc: DURATION_ADD function|DURATION_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: INTRATE function|INTRATE]], [[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: MDURATION function|MDURATION]], [[Documentation/How_Tos/Calc: MIRR function|MIRR]], [[Documentation/How_Tos/Calc: NOMINAL function|NOMINAL]], [[Documentation/How_Tos/Calc: NOMINAL_ADD function|NOMINAL_ADD]], [[Documentation/How_Tos/Calc: NPER function|NPER]], [[Documentation/How_Tos/Calc: NPV function|NPV]], [[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: PMT function|PMT]], [[Documentation/How_Tos/Calc: PPMT function|PPMT]], [[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: PV function|PV]], [[Documentation/How_Tos/Calc: RATE function|RATE]], [[Documentation/How_Tos/Calc: RECEIVED function|RECEIVED]], [[Documentation/How_Tos/Calc: RRI function|RRI]], [[Documentation/How_Tos/Calc: SLN function|SLN]], [[Documentation/How_Tos/Calc: SYD function|SYD]], [[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: VDB function|VDB]], [[Documentation/How_Tos/Calc: XIRR function|XIRR]], [[Documentation/How_Tos/Calc: XNPV function|XNPV]], [[Documentation/How_Tos/Calc: YIELD function|YIELD]], [[Documentation/How_Tos/Calc: YIELDDISC function|YIELDDISC]], [[Documentation/How_Tos/Calc: YIELDMAT function|YIELDMAT]]

:The Logical functions include boolean logic '''AND''', '''OR''', '''NOT''' functions, and functions such as '''IF''' which test a logical result.  

:[[Documentation/How_Tos/Calc: COS function|COS]], [[Documentation/How_Tos/Calc: SIN function|SIN]], [[Documentation/How_Tos/Calc: TAN function|TAN]], [[Documentation/How_Tos/Calc: COT function|COT]], [[Documentation/How_Tos/Calc: ACOS function|ACOS]], [[Documentation/How_Tos/Calc: ACOT function|ACOT]], [[Documentation/How_Tos/Calc: ASIN function|ASIN]], [[Documentation/How_Tos/Calc: ATAN function|ATAN]], [[Documentation/How_Tos/Calc: ATAN2 function|ATAN2]], [[Documentation/How_Tos/Calc: DEGREES function|DEGREES]], [[Documentation/How_Tos/Calc: RADIANS function|RADIANS]], [[Documentation/How_Tos/Calc: PI function|PI]]  

:[[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: TRUNC function|TRUNC]], [[Documentation/How_Tos/Calc: ROUND function|ROUND]], [[Documentation/How_Tos/Calc: ROUNDDOWN function|ROUNDDOWN]], [[Documentation/How_Tos/Calc: ROUNDUP function|ROUNDUP]], [[Documentation/How_Tos/Calc: CEILING function|CEILING]], [[Documentation/How_Tos/Calc: FLOOR function|FLOOR]], [[Documentation/How_Tos/Calc: EVEN function|EVEN]], [[Documentation/How_Tos/Calc: ODD function|ODD]], [[Documentation/How_Tos/Calc: MROUND function|MROUND]], [[Documentation/How_Tos/Calc: INT function|INT]], [[Documentation/How_Tos/Calc: QUOTIENT function|QUOTIENT]], [[Documentation/How_Tos/Calc: MOD function|MOD]]  

:[[Documentation/How_Tos/Calc: EXP function|EXP]], [[Documentation/How_Tos/Calc: POWER function|POWER]], [[Documentation/How_Tos/Calc: LOG function|LOG]], [[Documentation/How_Tos/Calc: LN function|LN]], [[Documentation/How_Tos/Calc: LOG10 function|LOG10]]  

:[[Documentation/How_Tos/Calc: ABS function|ABS]], [[Documentation/How_Tos/Calc: COMBIN function|COMBIN]], [[Documentation/How_Tos/Calc: COMBINA function|COMBINA]], [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]], [[Documentation/How_Tos/Calc: CONVERT_ADD function|CONVERT_ADD]], [[Documentation/How_Tos/Calc: COUNTBLANK function|COUNTBLANK]], [[Documentation/How_Tos/Calc: COUNTIF function|COUNTIF]], [[Documentation/How_Tos/Calc: DELTA function|DELTA]], [[Documentation/How_Tos/Calc: ERF function|ERF]], [[Documentation/How_Tos/Calc: ERFC function|ERFC]], [[Documentation/How_Tos/Calc: FACT function|FACT]], [[Documentation/How_Tos/Calc: FACTDOUBLE function|FACTDOUBLE]], [[Documentation/How_Tos/Calc: GCD function|GCD]], [[Documentation/How_Tos/Calc: GCD_ADD function|GCD_ADD]], [[Documentation/How_Tos/Calc: GESTEP function|GESTEP]], [[Documentation/How_Tos/Calc: ISEVEN function|ISEVEN]], [[Documentation/How_Tos/Calc: ISODD function|ISODD]], [[Documentation/How_Tos/Calc: LCM function|LCM]], [[Documentation/How_Tos/Calc: LCM_ADD function|LCM_ADD]], [[Documentation/How_Tos/Calc: MULTINOMIAL function|MULTINOMIAL]], [[Documentation/How_Tos/Calc: PRODUCT function|PRODUCT]], [[Documentation/How_Tos/Calc: RAND function|RAND]], [[Documentation/How_Tos/Calc: RANDBETWEEN function|RANDBETWEEN]], [[Documentation/How_Tos/Calc: SERIESSUM function|SERIESSUM]], [[Documentation/How_Tos/Calc: SIGN function|SIGN]], [[Documentation/How_Tos/Calc: SQRT function|SQRT]], [[Documentation/How_Tos/Calc: SQRTPI function|SQRTPI]], [[Documentation/How_Tos/Calc: SUBTOTAL function|SUBTOTAL]], [[Documentation/How_Tos/Calc: SUM function|SUM]], [[Documentation/How_Tos/Calc: SUMIF function|SUMIF]], [[Documentation/How_Tos/Calc: SUMSQ function|SUMSQ]]

:[[Documentation/How_Tos/Calc: BESSELI function|BESSELI]], [[Documentation/How_Tos/Calc: BESSELJ function|BESSELJ]], [[Documentation/How_Tos/Calc: BESSELK function|BESSELK]], [[Documentation/How_Tos/Calc: BESSELY function|BESSELY]]