| | | | | | |
| The Num Sum formula language | | | Sample Data | 10 | |
| supports functions and | | | | 30 | |
| mathematical operators | | | | 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)" | | | | |
| ROUND | "=ROUND(1.6)" | 2 | | | |
| RAND | "=RAND()" | 0.8987926314689921 | | | |
| TRUE | "=TRUE() || FALSE()" | true | | | |
| FALSE | "=TRUE() && 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 | | | |
| a <= b (less than or equal to test) | "=100<=F3" | | | | |
| a == b (equal to test) | "=F2==F3-20" | true | | | |
| a != b (inequality test) | "=F2!=F3" | true | | | |
| a > b (greater than test) | "=F2>F3" | | | | |
| a >= b (greater than or equal to test) | "=F2>=F3" | | | | |
| !a (boolean not) | "=!(F2 < 5)" | true | | | |
| a ? b : c (boolean if expression) | "=F2 == 10 ? F3 : F4" | 30 | | | |
| (a + b) / c (parentheses for expression precedence) | "=(F2 + F3) / F4" | 0.8 | | | |
| | | | | | |
| | | | | | |
| | | | | | |