Features
Spreadsheets help Features
| A | B | C | D | E | F | G | |
| 1 | Function | Arguments | Example | Result | Additional Information | Sample # | Sample Text |
| 2 | ABS | numbers_as_array | "=ABS(F4)" | 62 | 23 | Hello World | |
| 3 | AVERAGE | values_as_array | "=AVERAGE(F4:F14)" | 46.92307692307692 | Synonym:?AVG | 45 | True |
| 4 | CEILING | numbers_as_array | "=CEILING(F4:F14)" | 6,21E+016 | 62 | False | |
| 5 | COUNT | html_as_string | "=COUNT(F2:F14)" | 13 | 108 | To High | |
| 6 | DAYSFROM | url_as_string | "=DAYSFROM(2009,4,15)" | -11 | 200 | To Low | |
| 7 | DOLLAR | numbers_as_array | "=DOLLAR(F13)" | $55.00 | 36 | Perfect | |
| 8 | FALSE | "=IF(F4 < 100, TRUE(), FALSE())" | TRUE | 17 | number | ||
| 9 | FIXED | number, decimals, noCommas? | "=FIXED(F4+F14)" | 41.00 | Two decimal places | 99 | numbers_as_array |
| 10 | FLOOR | numbers_as_array | "=FLOOR(F4-F5)" | -46 | Synonym: INT | 100 | values_as_array |
| 11 | HYPERLINK | "=HYPERLINK("http://www.jquery.com", "jQuery's website")" | jQuery's website | -100 | html_as_string | ||
| 12 | IF | IF(logical_test, value_if_true, value_if_false) | "=IF(F12 < 100, TRUE(), FALSE())" | TRUE | Can have nested IF functions. | -14 | url_as_string |
| 13 | IMG | "=IMG("http://ui.jquery.com/images/logo.gif")" | The url can be sensitive to numbers. Also, on initial
load, because the image doesn't really have a size, the outerheight can be distorted. An easy way to offset this is to have some text in front of it that's taller than the image :). |
55 | values | ||
| 14 | MAX | values_as_array | "=MAX(F3:F13)" | 200 | -21 | ||
| 15 | MIN | values_as_array | "=MIN(F3:F13)" | -100 | |||
| 16 | N | numbers_as_array | "=N(F3)" | 45 | |||
| 17 | PI | "=PI()" | 3.141592653589793 | If you use "=PI" it will return the actual function as text, which is incorrect. Use "=PI()". | |||
| 18 | TODAY | "=TODAY()" | Wed Sep 15 2010 14:32:35 GMT-0400 (Eastern Daylight Time) | ||||
| 19 | TRUE | "=TRUE() || FALSE()" | TRUE | ||||
| 20 | SUM | values_as_array | "=SUM(F2:F13)" | 631 | |||
| 21 | ROUND | numbers_as_array | "=ROUND(1.6)" | 2 | |||
| 22 | RAND | "=RAND()" | 0.2405688383833392 | Synonym: RND |
| A | B | C | D | |
| 1 | Cell Navigation | Result | Dependancy | Synonym |
| 2 | Left Arrow | Active cell moves left if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 3 | Right Arrow | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 4 | Up Arrow | Active cell moves up if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 5 | Down Arrow | Active cell moves down if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| 6 | Escape | Active cell is removed from focus. | jQuery.sheet.evt.cellEditAbandon() | jS.evt.cellEditAbandon() |
| 7 | Enter | Starts in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| 8 | Ctrl + Enter | Ends in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() | jS.evt.formulaKeyDown() |
| 9 | Tab | Active cell moves right if possible. | jQuery.sheet.evt.cellClick() | jS.evt.cellClick() |
| A | B | C | D | E | F | |
| 1 | Chart Type | Example | Chart | Data | Month | Year |
| 2 | Vertical Bar | "=BARCHART(D2:D13) | TypeError: Cannot read properties of undefined (reading '4') |
| A | B | C | D | E | F | G | |
| 1 | Function | Arguments | Example | Results | Additional Information | Sample # | Sample Text |
| 2 | FACTORIAL | number | '=FACTORIAL(5)' | 120 | |||
| 3 | COMBINATION | number, number | '=COMBINATION(7,5) | 21 | |||
| 4 | PERMUTATION | number, number | '=PERMUTATION(7,5) | 2520 | |||
| 5 | GAMMA | number | |||||
| 6 | PRECISION | num, precision | |||||
| 7 | MINIMUM | array | |||||
| 8 | MODE | array | |||||
| 9 | MAXIMUM | array | |||||
| 10 | MEAN | array | |||||
| 11 | SUM | array | |||||
| 12 | MEDIAN | array | |||||
| 13 | QUARTILES | array | |||||
| 14 | VARIANCE | array | |||||
| 15 | MEANDEV | array | |||||
| 16 | STDEV | array | |||||
| 17 | COVARIANCE | array, array | |||||
| 18 | CORR_COEFF | array, array | |||||
| 19 | UNIFORMCDF | number, number, number | |||||
| 20 | BINOMIAL | number, number, number | |||||
| 21 | BIONOMIALCDF | num, num, num | |||||
| 22 | NEGBIN | num, num, num | |||||
| 23 | NEGBINCDF | N, m, n, x | |||||
| 24 | HYPGEOM | N, m, n, x | |||||
| 25 | HYPGEOMCDF | N, m, n, x | |||||
| 26 | EXPONENTIALCDF | l, x | |||||
| 27 | POISSON | l, x | |||||
| 28 | POISSONCDF | l, x | |||||
| 29 | NORMCDF | u, s, t | |||||
| 30 | LINEAR_REQ_EQ | array, array | |||||
| 31 | EXP_REG_EQ | array, array | |||||
| 32 | SECANTMETHOD | func, min, max, error, maxiter | |||||
| 33 | FIVEPT | func, x, h | |||||
| 34 | FCRIT | f, a b | |||||
| 35 | ASR | f, a b, precision |