Related Topics:

Function Wizard Functions

Spreadsheet Model Functions

Spreadsheet Simulation Functions

Spreadsheet Mathematical Functions

This section presents the mathematical functions that are available for spreadsheets within the Function Wizard in BlockSim. Note that many of these functions are also available in RENO flowcharts.

 

 

ABS DELTA LOGINV REPLACEB
ACOS DOLLAR LOGNORMDIST REPT
ACOSH ERF LOOKUP RIGHT
AND ERFC LOWER ROUND
ASIN ERROR.TYPE MATCH ROUNDDOWN
ASINH EVEN MAX ROUNDUP
ATAN EXACT MID ROW
ATAN2 EXP MIN ROWS
ATANH EXPONDIST MINUTE SEARCH
AVERAGE FACT MIRR SEARCHB
BESSELI FACTDOUBLE MOD SECOND
BESSELJ FALSE MONTH SIGN
BESSELK FDIST MROUND SIN
BESSELY FIND N SINH
BETADIST FINDB NA SLN
BETAINV FINV NEGBINOMDIST SQRT
BINOMDIST FISHER NORMDIST STANDARDIZE
CEILING FISHERINV NORMINV STDEV
CHAR FIXED NORMSDIST STDEVP
CHIDIST FLOOR NORMSINV SUBSTITUTE
CHIINV FV NOT SUM
CHOOSE GAMMADIST NOW SUMIF
CLEAN GAMMAINV NPER SUMSQ
CODE GAMMALN NPV SYD
COLUMN HLOOKUP ODD T
COLUMNS HOUR OFFSET TAN
COMBIN HYPGEOMDIST OR TANH
CONCATENATE IF PERMUT TEXT
CONFIDENCE INT PI TIME
COS IPMT PMT TIMEVALUE
COSH IRR POISSON TODAY
COUNT ISBLANK PPMT TRIM
COUNTA ISERR PRODUCT TRUE
COUNTIF ISERROR PROPER TRUNC
CRITBINOM ISLOGICAL PV TYPE
CUMIPMT ISNONTEXT QUOTIENT UPPER
CUMPRINC ISNUMBER RADIANS VALUE
DATE ISREF RAND VAR
DATEVALUE ISTEXT RANK VARP
DAY LEFT RATE VDB
DAYS360 LEN RDT_NPB_C VLOOKUP
DB LN RDT_NPB_N WEEKDAY
DDB LOG RDT_NPB_R WEIBULL
DEGREES LOG10 REPLACE YEAR

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.