true-plus-zero |
op:+ |
=TRUE+0 |
value |
1 |
false-plus-zero |
op:+ |
=FALSE+0 |
value |
1 |
true-plus-one |
op:+ |
=TRUE+1 |
value |
1 |
true-times-true |
op:* |
=TRUE*TRUE |
value |
1 |
true-minus-false |
op:- |
=TRUE-FALSE |
value |
1 |
sum-with-booleans |
SUM |
=SUM(TRUE, FALSE, TRUE) |
value |
2 |
sum-of-boolean-range |
SUM |
=SUM(A1:A3) |
value |
1 |
average-with-booleans |
AVERAGE |
=AVERAGE(TRUE, FALSE, TRUE) |
value |
2 |
numeric-string-plus-zero |
op:+ |
="1"+0 |
value |
|
numeric-string-plus-numeric-string |
op:+ |
="2"+"3" |
value |
|
numeric-string-times-number |
op:* |
="5"*2 |
value |
|
non-numeric-string-plus-number |
op:+ |
="abc"+1 |
value |
|
empty-string-plus-number |
op:+ |
=""+1 |
value |
2 |
whitespace-string-plus-number |
op:+ |
=" "+1 |
value |
|
sum-with-numeric-string |
SUM |
=SUM("1", "2", "3") |
value |
2 |
sum-of-string-range |
SUM |
=SUM(A1:A3) |
value |
|
number-concat-number |
op:& |
=1&2 |
value |
|
boolean-concat-string |
op:& |
=TRUE&"x" |
value |
1 |
number-concat-boolean |
op:& |
=1&TRUE |
value |
1 |
error-concat-string-type-coercion |
op:& |
=#N/A&"x" |
error-code |
|
blank-cell-plus-number |
op:+ |
=A1+1 |
value |
|
blank-cell-in-arithmetic |
op:* |
=A1*10 |
value |
|
blank-cell-in-concatenation |
op:& |
=A1&"x" |
value |
|
blank-equals-zero |
op:= |
=A1=0 |
value |
|
blank-equals-empty-string |
op:= |
=A1="" |
value |
|
zero-equals-empty-string |
op:= |
=0="" |
value |
|
number-less-than-string |
op:< |
=1<"a" |
value |
|
string-less-than-number |
op:< |
="a"<1 |
value |
|
boolean-equals-number |
op:= |
=TRUE=1 |
value |
1 |
boolean-less-than-number |
op:< |
=TRUE<2 |
value |
|
string-comparison-case-sensitivity |
op:= |
="a"="A" |
value |
|
numeric-string-equals-number |
op:= |
="1"=1 |
value |
|
unary-minus-on-true |
op:unary- |
=-TRUE |
value |
1 |
unary-minus-on-numeric-string |
op:unary- |
=-"5" |
value |
|
double-unary-on-true |
op:unary- |
=--TRUE |
value |
2 |
double-unary-on-false |
op:unary- |
=--FALSE |
value |
2 |
unary-plus-on-string |
op:unary+ |
=+"5" |
value |
1 |
n-of-true-type-coercion |
N |
=N(TRUE) |
value |
1 |
n-of-false-type-coercion |
N |
=N(FALSE) |
value |
1 |
n-of-string |
N |
=N("hello") |
value |
|
n-of-number-type-coercion |
N |
=N(42) |
value |
|
n-of-error-type-coercion |
N |
=N(#VALUE!) |
error-code |
|
t-of-string |
T |
=T("hello") |
value |
|
t-of-number |
T |
=T(42) |
value |
1 |
t-of-boolean |
T |
=T(TRUE) |
value |
|
value-of-numeric-string |
VALUE |
=VALUE("123.45") |
value |
|
value-of-non-numeric-string |
VALUE |
=VALUE("abc") |
value |
|
value-of-boolean-string |
VALUE |
=VALUE("TRUE") |
value |
|
text-number-with-format |
TEXT |
=TEXT(1234.5, "#,##0.00") |
format |
1 |
boolean-array-in-sum |
SUM |
=SUM({TRUE,FALSE,TRUE}) |
value |
|
mixed-array-in-sum |
SUM |
=SUM({1,"2",TRUE}) |
value |
|
string-array-in-product |
PRODUCT |
=PRODUCT({"2","3","4"}) |
value |
|
n-over-boolean-array |
N |
=N({TRUE,FALSE,TRUE}) |
value |
1 |