| | | | | | | |
| | 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.5455359446350485 | | | |
| | 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 | | | |
| | | | | | | |
| | | | | | | |
| | | | | | | |