14c699 |
TRUE |
=TRUE() |
value |
|
d19351 |
FALSE |
=FALSE() |
value |
|
f932ba |
SORTN |
=SORTN({5;2;8;1;4}, 3) |
value |
1 |
3d3ee3 |
SORTN |
=SORTN({5;2;8;1;4}, 3, 0, 1, TRUE) |
value |
1 |
edca79 |
ENCODEURL |
=ENCODEURL("a b") |
value |
1 |
86a3a1 |
ENCODEURL |
=ENCODEURL("hello world/?&=") |
value |
1 |
19f70d |
ISURL |
=ISURL("https://example.com") |
value |
1 |
b6ce2e |
ISURL |
=ISURL("not a url") |
value |
1 |
4dd1db |
HYPERLINK |
=HYPERLINK("https://example.com", "click me") |
value |
|
fb9993 |
HYPERLINK |
=HYPERLINK("https://example.com") |
value |
|
1e60d8 |
IMPORTDATA |
=IMPORTDATA("https://example.com/data.csv") |
value |
1 |
53dfd2 |
IMPORTFEED |
=IMPORTFEED("https://example.com/feed.xml") |
value |
1 |
2facb6 |
IMPORTHTML |
=IMPORTHTML("https://example.com/page.html", "table", 1) |
value |
1 |
a9693a |
IMPORTXML |
=IMPORTXML("https://example.com/data.xml", "//title") |
value |
1 |
b31415 |
IMPORTRANGE |
=IMPORTRANGE("https://docs.google.com/spreadsheets/d/abc123", "Sheet1!A1:B2") |
value |
1 |
e8510f |
ARRAYFORMULA |
=ARRAYFORMULA({1;2;3} * 2) |
value |
2 |
8b988c |
ARRAYFORMULA |
=ARRAYFORMULA({"a";"b"} & "!") |
value |
2 |
c94b38 |
QUERY |
=QUERY({1,"a";2,"b";3,"c"}, "select *") |
value |
2 |
1c884b |
QUERY |
=QUERY({1,"a";2,"b";3,"c"}, "select Col2") |
value |
2 |
b2be2b |
GOOGLEFINANCE |
=GOOGLEFINANCE("GOOG", "price") |
value |
2 |
726dd4 |
GOOGLETRANSLATE |
=GOOGLETRANSLATE("hello", "en", "es") |
value |
2 |
86dc5a |
DETECTLANGUAGE |
=DETECTLANGUAGE("hello world") |
value |
2 |
713244 |
IMAGE |
=IMAGE("https://example.com/pic.png") |
value |
1 |
0180e6 |
SPARKLINE |
=SPARKLINE({1;2;3;4;5}) |
value |
2 |