Manuals/calci/help

From ZCubes Wiki
Revision as of 21:36, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="1SpaceContent" align="left"><div class="canframedcontent"><div class="compressed"></div><div></div></div> ---- <div id="5SpaceContent" align="left"></div></div> --...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Function

SUM

DAVERAGE

DCOUNT

DCOUNTA

DGET

DMAX

DMIN

DPRODUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

DATE

DATEVALUE

DAY

DAYS360

EDATE

EOMONTH

HOUR

MINUTE

MONTH

NETWORKDAYS

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WORKDAY

YEAR

YEARFRAC

BESSELI

BESSELJ

BESSELK

BESSELY

BIN2DEC

BIN2HEX

BIN2OCT

COMPLEX

CONVERT

DEC2BIN

DEC2HEX

DEC2OCT

DELTA

ERF

ERFC

GESTEP

HEX2BIN

HEX2DEC

HEX2OCT

IMABS

IMAGINARY

IMARGUMENT

IMCONJUGATE

IMCOS

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

IMPOWER

IMPRODUCT

IMREAL

IMSIN

IMSQRT

IMSUB

IMSUM

OCT2BIN

OCT2DEC

OCT2HEX

ACCRINT

ACCRINTM

AMORDEGRC

AMORLINC

COUPDAYBS

COUPDAYS

COUPDAYSNC

COUPNCD

COUPNUM

COUPPCD

CUMIPMT

CUMPRINC

DB

DDB

DISC

DOLLARDE

DOLLARFR

DURATION

EFFECT

FV

FVSCHEDULE

INTRATE

IPMT

IRR

ISPMT

MDURATION

MIRR

NOMINAL

NPER

NPV

ODDFPRICE

ODDFYIELD

ODDLPRICE

ODDLYIELD

PMT

PPMT

PRICE

PRICEDISC

PRICEMAT

PV

RATE

RECEIVED

SLN

SYD

TBILLEQ

TBILLPRICE

TBILLYIELD

VDB

XIRR

XNPV

YIELD

YIELDDISC

YIELDMAT

CELL

ERROR.TYPE

INFO

ISBLANK

ISERR

ISERROR

ISEVEN

ISLOGICAL

ISNA

ISNONTEXT

ISNUMBER

ISODD

ISREF

ISTEXT

N

NA

TYPE

AND

FALSE

IF

NOT

OR

TRUE

ADDRESS

AREAS

CHOOSE

COLUMN

COLUMNS

GETPIVOTDATA

HLOOKUP

HYPERLINK

INDEX

INDIRECT

LOOKUP

MATCH

OFFSET

ROW

ROWS

RTD

TRANSPOSE

VLOOKUP

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

SIN

SINH

SQRT

SQRTPI

SUBTOTAL

SUM

SUMIF

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMXMY2

TAN

TANH

TRUNC

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

ASC

BAHTTEXT

CHAR

CLEAN

CODE

CONCATENATE

DOLLAR

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

EUROCONVERT

SQL.REQUEST