|
»Spread for Windows Forms
» Product Tour
» Formulas
|
|
jump to:
|
|
Formulas |
|
Spread's powerful Calc Engine includes over 300 built-in functions, supports cross-sheet formula referencing, and gives you the ability to define your own custom functions.
With formulas, you can
Specify a cell reference
Use a circular reference
Nest functions
Recalculate and update formulas automatically
Allow the user to enter formulas
Create and use a custom name
Create and use a custom function
Following are the included functions:
Database Functions |
| DAVERAGE |
DCOUNT |
DCOUNTA |
DGET |
| DMAX |
DMIN |
DPRODUCT |
DSTDEV |
| DSTDEVP |
DSUM |
DVAR |
DVARP |
Date and Time Functions |
| DATE |
DATEDIF |
DATEVALUE |
DAY |
| DAYS360 |
EDATE |
EOMONTH |
HOUR |
| MINUTE |
MONTH |
NETWORKDAYS |
NOW |
| SECOND |
TIME |
TIMEVALUE |
TODAY |
| WEEKDAY |
WEEKNUM |
WORKDAY |
YEAR |
| YEARFRAC |
|
|
|
Engineering Functions |
| 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 |
|
Financial Functions |
| ACCRINT |
ACCRINTM |
AMORDEGRC |
AMORLINC |
| COUPDAYS |
COUPDAYBS |
COUPDAYSNC |
COUPNCD |
| COUPNUM |
COUPPCD |
CUMIPMT |
CUMPRINC |
| DB |
DDB |
DISC |
DOLLAR |
| DOLLARDE |
DOLLARFR |
DURATION |
EFFECT |
| EURO |
EUROCONVERT |
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 |
Information Functions |
| COUNTBLANK |
ERRORTYPE |
ISBLANK |
ISERR |
| ISERROR |
ISEVEN |
ISLOGICAL |
ISNA |
| ISNONTEXT |
ISNUMBER |
ISODD |
ISREF |
| ISTEXT |
N |
NA |
TYPE |
Logical Functions |
| AND |
FALSE |
IF |
NOT |
| OR |
TRUE |
|
|
Look Up Functions |
| ADDRESS |
CHOOSE |
COLUMN |
COLUMNS |
| HLOOKUP |
INDEX |
LOOKUP |
OFFSET |
| ROW |
ROWS |
TRANSPOSE |
VLOOKUP |
Math and Trigonometry Functions |
| ABS |
ACOS |
ACOSH |
ASIN |
| ASINH |
ATAN |
ATAN2 |
ATANH |
| CEILING |
COMBIN |
COS |
COSH |
| COUNTIF |
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 |
Statistical Functions |
| AVEDEV |
AVERAGE |
AVERAGEA |
BETADIST |
| BETAINV |
BINOMDIST |
CHIDIST |
CHIINV |
| CHITEST |
CONFIDENCE |
CORREL |
COUNT |
| COUNTA |
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 Functions |
| CHAR |
CLEAN |
CODE |
CONCATENATE |
| DOLLAR |
EXACT |
FIND |
FIXED |
| LEFT |
LEN |
LOWER |
MID |
| PROPER |
REPLACE |
REPT |
RIGHT |
| SUBSTITUTE |
T |
TRIM |
UPPER |
| VALUE |
|
|
|