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