See:
Function |
Arguments |
Example |
Result |
Additional Information |
Sample # |
Sample Text |
ABS |
numbers_as_array |
"=ABS(F4)" |
62 |
|
23 |
Hello World |
AVERAGE |
values_as_array |
"=AVERAGE(F4:F14)" |
46.92307692307692 |
Synonym:?AVG |
45 |
True |
CEILING |
numbers_as_array |
"=CEILING(F4:F14)" |
6,21E+016 |
|
62 |
False |
COUNT |
html_as_string |
"=COUNT(F2:F14)" |
13 |
|
108 |
To High |
DAYSFROM |
url_as_string |
"=DAYSFROM(2009,4,15)" |
-11 |
|
200 |
To Low |
DOLLAR |
numbers_as_array |
"=DOLLAR(F13)" |
$55.00 |
|
36 |
Perfect |
FALSE |
|
"=IF(F4 < 100, TRUE(), FALSE())" |
TRUE |
|
17 |
number |
FIXED |
number, decimals, noCommas? |
"=FIXED(F4+F14)" |
41.00 |
Two decimal places |
99 |
numbers_as_array |
FLOOR |
numbers_as_array |
"=FLOOR(F4-F5)" |
-46 |
Synonym: INT |
100 |
values_as_array |
HYPERLINK |
|
"=HYPERLINK("http://www.jquery.com", "jQuery's website")" |
jQuery's website |
|
-100 |
html_as_string |
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 |
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 |
MAX |
values_as_array |
"=MAX(F3:F13)" |
200 |
|
-21 |
|
MIN |
values_as_array |
"=MIN(F3:F13)" |
-100 |
|
|
|
N |
numbers_as_array |
"=N(F3)" |
45 |
|
|
|
PI |
|
"=PI()" |
3.141592653589793 |
If you use "=PI" it will return the actual function as text, which is incorrect. Use "=PI()". |
|
|
TODAY |
|
"=TODAY()" |
Wed Sep 15 2010 14:32:35 GMT-0400 (Eastern Daylight Time) |
|
|
|
TRUE |
|
"=TRUE() || FALSE()" |
TRUE |
|
|
|
SUM |
values_as_array |
"=SUM(F2:F13)" |
631 |
|
|
|
ROUND |
numbers_as_array |
"=ROUND(1.6)" |
2 |
|
|
|
RAND |
|
"=RAND()" |
0.2405688383833392 |
Synonym: RND |
|
|
Cell Navigation |
Result |
Dependancy |
Synonym |
Left Arrow |
Active cell moves left if possible. |
jQuery.sheet.evt.cellClick() |
jS.evt.cellClick() |
Right Arrow |
Active cell moves right if possible. |
jQuery.sheet.evt.cellClick() |
jS.evt.cellClick() |
Up Arrow |
Active cell moves up if possible. |
jQuery.sheet.evt.cellClick() |
jS.evt.cellClick() |
Down Arrow |
Active cell moves down if possible. |
jQuery.sheet.evt.cellClick() |
jS.evt.cellClick() |
Escape |
Active cell is removed from focus. |
jQuery.sheet.evt.cellEditAbandon() |
jS.evt.cellEditAbandon() |
Enter |
Starts in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() |
jS.evt.formulaKeyDown() |
Ctrl + Enter |
Ends in-place edit / Active cell moves
down if possible. |
jQuery.sheet.evt.formulaKeyDown() |
jS.evt.formulaKeyDown() |
Tab |
Active cell moves right if possible. |
jQuery.sheet.evt.cellClick() |
jS.evt.cellClick() |
Chart Type |
Example |
Chart |
Data |
Month |
Year |
Vertical Bar |
"=BARCHART(D2:D13) |
<div class="jSheetChart"><svg height="172" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M80,139L58,139L58,127L80,127Z" stroke="none" fill="#1751a7"></path><path d="M108,139L86,139L86,1 |
4 |
Jan |
2001 |
Horizontal Bar |
"=HBARCHART(D2:D13) |
<div class="jSheetChart"><svg height="148" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path d="M53,27L53,20L95,20L95,27Z" stroke="none" fill="#1751a7"></path><path d="M53,36L53,29L116,29L116, |
6 |
Feb |
2002 |
Pie |
"=LINECHART(D2:D8, F2:F6)" |
<div class="jSheetChart"><svg height="220" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><text fill="#000000" stroke="none" font="12px Arial, sans-serif" style="text-anchor: middle; font: 12px A |
7.2 |
Mar |
2003 |
Line |
"=PIECHART(D2:D8, E2:E8)" |
<div class="jSheetChart"><svg height="144" width="421" version="1.1" xmlns="http://www.w3.org/2000/svg"><desc>Created with Raphaël</desc><defs></defs><path stroke-linejoin="round" stroke-width="1" style="stroke-width: 1; stroke-linejoin: round;" d="M210.5 |
7.5 |
Apr |
2004 |
|
|
|
8.2 |
May |
2005 |
|
|
|
9.1 |
Jun |
2006 |
|
|
|
14.1 |
Jul |
2007 |
|
|
|
16 |
Aug |
2008 |
|
|
|
17.9 |
Sep |
2009 |
|
|
|
22 |
Oct |
2010 |
|
|
|
30 |
Nov |
2011 |
|
|
|
32 |
Dec |
2012 |
|
|
|
|
|
|
|
|
|
|
|
|
Inputs are for capturing fixed data, such as a drop down list (INPUT.SELECT), or a checkbox (INPUT.CHECKBOX) |
|
|
|
|
|
|
|
Input Type |
Example |
|
|
|
Data Number |
|
Data String |
Select List |
"=INPUT.SELECT(D3:D10)" |
|
|
|
34 |
|
Lorem |
Radio List |
"=INPUT.RADIO(E3:E10)" |
Lorem
Proin
Aliquam
Quisque
Aliquam
Vivamus
Etiam
Donec |
|
|
-20 |
|
Proin |
Checkbox |
"=INPUT.CHECKBOX(E3)" |
Lorem |
|
|
123 |
|
Aliquam |
Get Select List Value |
"=INPUT.SELECTVAL(C3)" |
4 |
|
|
123 |
|
Quisque |
Get Radio List Value |
"=INPUT.RADIOVAL(C4)" |
Donec |
|
|
4 |
|
Aliquam |
Get Checkbox Value |
"=INPUT.CHECKBOXVAL(C5)" |
Lorem |
|
|
534456 |
|
Vivamus |
Detect if Checkbox is Checked |
"=INPUT.ISCHECKED(C5)" |
FALSE |
|
|
3 |
|
Etiam |
|
|
|
|
|
1 |
|
Donec |
Function |
Arguments |
Example |
Results |
Additional Information |
Sample # |
Sample Text |
FACTORIAL |
number |
'=FACTORIAL(5)' |
120 |
|
|
|
COMBINATION |
number, number |
'=COMBINATION(7,5) |
21 |
|
|
|
PERMUTATION |
number, number |
'=PERMUTATION(7,5) |
2520 |
|
|
|
GAMMA |
number |
|
|
|
|
|
PRECISION |
num, precision |
|
|
|
|
|
MINIMUM |
array |
|
|
|
|
|
MODE |
array |
|
|
|
|
|
MAXIMUM |
array |
|
|
|
|
|
MEAN |
array |
|
|
|
|
|
SUM |
array |
|
|
|
|
|
MEDIAN |
array |
|
|
|
|
|
QUARTILES |
array |
|
|
|
|
|
VARIANCE |
array |
|
|
|
|
|
MEANDEV |
array |
|
|
|
|
|
STDEV |
array |
|
|
|
|
|
COVARIANCE |
array, array |
|
|
|
|
|
CORR_COEFF |
array, array |
|
|
|
|
|
UNIFORMCDF |
number, number, number |
|
|
|
|
|
BINOMIAL |
number, number, number |
|
|
|
|
|
BIONOMIALCDF |
num, num, num |
|
|
|
|
|
NEGBIN |
num, num, num |
|
|
|
|
|
NEGBINCDF |
N, m, n, x |
|
|
|
|
|
HYPGEOM |
N, m, n, x |
|
|
|
|
|
HYPGEOMCDF |
N, m, n, x |
|
|
|
|
|
EXPONENTIALCDF |
l, x |
|
|
|
|
|
POISSON |
l, x |
|
|
|
|
|
POISSONCDF |
l, x |
|
|
|
|
|
NORMCDF |
u, s, t |
|
|
|
|
|
LINEAR_REQ_EQ |
array, array |
|
|
|
|
|
EXP_REG_EQ |
array, array |
|
|
|
|
|
SECANTMETHOD |
func, min, max, error, maxiter |
|
|
|
|
|
FIVEPT |
func, x, h |
|
|
|
|
|
FCRIT |
f, a b |
|
|
|
|
|
ASR |
f, a b, precision |
|
|
|
|
|
|