Num Sum formula language

Saving...

| cells cell options

| spreadsheet formula options

Num Sum formula language by steveyen


The Num Sum formula language supports functions and mathematical operators			Sample Data Used Below:	10
				30
				50

Function Name	Example	Result
SUM	"=SUM(F2:F4)"	90
AVERAGE	"=AVERAGE(F2:F4)"	30
COUNT	"=COUNT(F2:F4)"	3
MIN	"=MIN(F2:F4)"	10
MAX	"=MAX(F2:F4)"	50
ABS	"=ABS(F3-F4)"	20
CEILING	"=CEILING(F2/F3)"	1
FLOOR	"=FLOOR(F2/F3)"	0 0
ROUND	"=ROUND(1.6)"	2
RAND	"=RAND()"	0.985650726839389
TRUE	"=TRUE() \|\| FALSE()"	true
FALSE	"=TRUE() && FALSE()"	false false
FIXED	"=FIXED(1234.2345)"	1,234.23
	"=FIXED(1234.2345, 3)"	1,234.235	2nd argument is number of decimal places.
DOLLAR	"=DOLLAR(123.456)"	$123.46	Converts a number into a US currency string.
N	"=N(D21)"	123.46	N converts a value into a number.

a * b (multiply)	"=F2F3F4"	15000
a / b (divide)	"=F2/F3/F4"	0.006666666666666666
a + b (add)	"=F2+F3+F4"	90
a - b (subtract)	"=F2-F3"	-20
a % b (modulo or remainder)	"=F2 % F3"	10
a < b (less than test)	"=F2<100"	true true
a <= b (less than or equal to test)	"=100<=F3"	false false
a == b (equal to test)	"=F2==F3-20"	true true
a != b (inequality test)	"=F2!=F3"	true true
a > b (greater than test)	"=F2>F3"	false false
a >= b (greater than or equal to test)	"=F2>=F3"	false false
!a (boolean not)	"=!(F2 < 5)"	true true
a ? b : c (boolean if expression)	"=F2 == 10 ? F3 : F4"	30 30
(a + b) / c (parentheses for expression precedence)	"=(F2 + F3) / F4"	0.8



(This page was created as a Num Sum spreadsheet and published/exported as a HTML page.) (This page was created as a Num Sum spreadsheet and published/exported as a HTML page.)

	Number Formatting
		none		1,234 1,234.56 $1,234 $1,234.56		1234 1234.56 25% 25.35%		Currency symbol: Decimal places:

	Row/Column Options
		insert row before insert row after		insert column before insert column after		remove row remove column

	Font Formatting
		B I U		strike a⁺ a^-