Here are a list of all the functions and calculations the CERF Table Tool can perform:
note: to use these functions in the tool, place an equals sign before the “usage” expression. ie = 3<2
| Function Description | Usage | Output |
| False | FALSE | 0 |
| True | TRUE | 1 |
| Less than (<) | 3<2 | 0 (false) |
| Greater than (>) | 3>2 | 1 (true) |
| Less than or equal (<=) | 3<=2 | 0 (false) |
| Greater than or equal (>=) | 3<=3 | 1 (true) |
| Equal (=) | 3 = 3 | 1 (true) |
| Not Equal (<>) | 3 <> 3 | 0 (false) |
| Not (#NOT): there should be no space between #NOT and the argument you’re using | #NOT#3>2 | 0 (false) |
| And (#AND) |
(3>2)#AND#(2>1) (3>2)#AND#(1>2) |
1 (true) 0 (false) |
| Or (#OR) | (3>2)#OR#(1>2) | 1 (true) |
|
Nor (#NOR): if both arguments are false then the answer will be true if one of the arguments are true, the answer will be false |
(1<0)#NOR#(0>1) (1<0)#NOR#(0<1) |
1 (true) 0 (false) |
|
Nand (#NAND): if both arguments are true, the answer will be false if one of the arguments are true, the answer will be true |
(1>0)#NAND#(0<1) (1<0)#NAND#(0<1) |
0 (false) 1 (true) |
| Equivalence (#EQU): if both arguments are true or both arguments are false, the answer will be true | (1>0)#EQU#(0<1) | 1 (true) |
|
Implication (arg1#IMP#arg2): if arg1 is true and arg2 is true the answer will be true if arg1 is false and arg2 is true, the answer will be true if arg1 is false and arg2 is false, the answer will be true if arg1 is true and arg2 is false, the answer will be false |
(1>0)#IMP#(0<1) (1<0)#IMP#(0<1) (1<0)#IMP#(0>1) (1>0)#IMP#(0>1) |
1 (true) 1 (true) 1 (true) 0 (false) |
| Absolute value: takes the absolute value of the number | ABS(-7) | 7 |
| Integer: rounds to the nearest whole number | INT(2.5) | 3 |
| Square Root: takes the square root of the number, will return NaN if the number is negative | SQRT(9) | 3 |
| Log: takes the base 10 log of the input | LOG(100) | 1.999999999 |
| Natural log | LN(e) | 1 |
| Pi | PI or pi | 3.141592653589793 |
| E | E or e | 2.718281828459045 |
|
String Length: returns the length of the string input (including spaces and punctuation). If the input is a number the output will be 0 |
LENGTH(“The Dog.”) LENGTH(92) |
8 0 |
|
Value: returns the number value of the input If the input is a word the output will be 0 |
VALUE(“123.4”) VALUE(“DOG”) |
123.4 0 |
|
SUM: will return the sum of the values ie. [D1] = 3, [D2] = 4, [D3] = 1 |
SUM([D1,D2,D3]) SUM([1,2,3]) |
8 6 |
| Average: will return the average of the values |
AVG([D1,D2,D3]) AVG([4,3,1]) |
2.67 2.67 |
| Min: will return the minimum of the series |
MIN([D1,D2,D3]) MIN([4,3,1]) |
1 1 |
| Max: will return the maximum of the series |
MAX([D1,D2,D3]) MAX([4,3,1]) |
4 4 |
|
Sum Squares: will return the sum of the squared values in the series ie. (4^2) + (3^2) + (1^2) = output |
SUMSQ([D1,D2,D3]) SUMSQ([4,3,1]) |
26 26 |
|
Choose (CHOOSE(x,[y1,y2,y3,y4…..yn]): chooses the xth index of the list (note: the list values must be numbers) ie if x = 2, the output would be y2, if x = 10 but there are only 4 variables, the output will be 0 |
CHOOSE(3,[D1,D2,D3]) CHOOSE(3,[21,45,123,53]) CHOOSE(10,[21,45,123,53]) |
1 123 0 |
|
Row Count: returns the number of rows ie. ROWS(D97..H99), there rows are 97,98,99 |
ROWS(D97..H99) |
3 |
|
Column Count: returns the number of columns ie. COL(D97..L99), there rows are D,E,F,G,H,I,J,K,L |
COLS(D97..L99) | 9 |
< CERF Resource up Word or Excel >