| 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) | "=F2*F3*F4" | 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.) | ||||||