Global Usage Rule SpreadsheetFunctions
The following information assumes a basic to medium level understanding of creating and using spreadsheets and is not intended to teach how to create or use a spreadsheet.
The following table lists the functions recognized by Gotransverse when a usage rule spreadsheet is uploaded. Functions not listed below must not be used when creating a usage rule spreadsheet. In addition, a simple example of the function is provided as well as a sample of the type of result to expect (refer to Global Usage Rule Examples). There is no requirement that these functions be used as stand-alone functions. Several of the examples demonstrate many of the calculations employing compound structures including multiple functions, nested functions, and compound nested functions.
| Function | Example | Sample Result |
|---|---|---|
| ADDITION | =4+B27+1 | 17 |
| AND | =AND(1;B25;B45) | True |
| AVERAGE | =AVERAGE(B6:B11; C6; 32; 13; C7) | 28209.81 |
| CONCATENATE | ="TEST "&C25&" SOMETHING "&C27 | TEST TRUE SOMETHING 12 |
| DIVIDE | =(1000/3)/(2/2) | 333.33 |
| EQUAL | =C36=C39 | True |
| GREATER THAN | =B39>B33 | True |
| GREATER THAN EQUAL | =B35>=B29 | True |
| IF | =IF(D4=1;"Value True"; "Value False") | Value True |
| ISBLANK | =ISBLANK(B11) | True |
| ISERROR | =ISERROR(C25) | False |
| LEFT | =LEFT("Sample",3) | Sam |
| LEN | =LEN("Sample") | 6 |
| LOOKUP | =LOOKUP(B12,A1:A10) | Premium |
| LESS THAN | =B39<B33 | False |
| LESS THAN EQUAL | =B35<=B29 | False |
| MAX | =MAX(1; 3; C8:D15; D4) | 281982.11 |
| MIN | =MIN(1; 3; C6:D12; D2) | 1 |
| MULTIPLY | =(14* 4 *2)*(12*4) | 5376 |
| NOT | =NOT(B45) | False |
| NOT EQUAL | =B22<>B34 | True |
| OR | =OR(B24;B46;0) | False |
| PERCENTILE | =PERCENTILE(B2/C2) | 84% |
| POWER | =POWER(A2, B2) | 512 |
| RIGHT | =RIGHT("Sample",3) | ple |
| ROUND | =ROUND(21.2445; 2) | 21.24 |
| ROUNDDOWN | =ROUNDDOWN(21.2445; 2) | 21.24 |
| ROUNDUP | =ROUNDUP(21.2445; 2) | 21.24 |
| SUBTRACTION | =3-2-3-4 | -6 |
| SUM | =SUM(D2:D5;B6;B7) | 9 |
| UNARY MINUS | =SUMPRODUCT(--(B5:B9=C5:C9)) | 4 |
| VLOOKUP (See note below) | =VLOOKUP(1;F3:G6;2; 0) | 2 |
For VLOOKUP, only use the exact match functionality (false), not the closest or nearest match (true). The nearest match works in the spreadsheet but not in Gotransverse.