type-coercion
| Test | Subject | Formula | Category | DVs |
|---|---|---|---|---|
aa556d |
op:+ | =TRUE+0 |
value | 1 |
e7ef6e |
op:+ | =FALSE+0 |
value | 1 |
b322a2 |
op:+ | =TRUE+1 |
value | 1 |
cf6f56 |
op:* | =TRUE*TRUE |
value | 1 |
261fa9 |
op:- | =TRUE-FALSE |
value | 1 |
255ef9 |
SUM | =SUM(TRUE, FALSE, TRUE) |
value | 2 |
569654 |
SUM | =SUM(A1:A3) |
value | 1 |
3e62ee |
AVERAGE | =AVERAGE(TRUE, FALSE, TRUE) |
value | 2 |
f6f802 |
op:+ | ="1"+0 |
value | |
b0a93f |
op:+ | ="2"+"3" |
value | |
1b05cd |
op:* | ="5"*2 |
value | |
e0de66 |
op:+ | ="abc"+1 |
value | |
ed098c |
op:+ | =""+1 |
value | 2 |
2827bf |
op:+ | =" "+1 |
value | |
9c608d |
SUM | =SUM("1", "2", "3") |
value | 2 |
b46e19 |
SUM | =SUM(A1:A3) |
value | |
4e834f |
op:& | =1&2 |
value | |
31a795 |
op:& | =TRUE&"x" |
value | 1 |
85af0e |
op:& | =1&TRUE |
value | 1 |
1b840a |
op:& | =#N/A&"x" |
error-code | |
c0f119 |
op:+ | =A1+1 |
value | |
d395a4 |
op:* | =A1*10 |
value | |
bedea4 |
op:& | =A1&"x" |
value | |
9bf0c0 |
op:= | =A1=0 |
value | |
d182ec |
op:= | =A1="" |
value | |
e01c91 |
op:= | =0="" |
value | |
545921 |
op:< | =1<"a" |
value | |
2615b8 |
op:< | ="a"<1 |
value | |
e78ee8 |
op:= | =TRUE=1 |
value | 1 |
64fc3f |
op:< | =TRUE<2 |
value | |
5e2534 |
op:= | ="a"="A" |
value | |
6a37aa |
op:= | ="1"=1 |
value | |
cccf83 |
op:unary- | =-TRUE |
value | 1 |
1c353d |
op:unary- | =-"5" |
value | |
93d26b |
op:unary- | =--TRUE |
value | 2 |
71c9e5 |
op:unary- | =--FALSE |
value | 2 |
8fe0d5 |
op:unary+ | =+"5" |
value | 1 |
b17004 |
N | =N(TRUE) |
value | 1 |
6567ec |
N | =N(FALSE) |
value | 1 |
03b5d3 |
N | =N("hello") |
value | |
473584 |
N | =N(42) |
value | |
a4f4c3 |
N | =N(#VALUE!) |
error-code | |
05873e |
T | =T("hello") |
value | |
5c060d |
T | =T(42) |
value | 1 |
2bfae3 |
T | =T(TRUE) |
value | |
eb786c |
VALUE | =VALUE("123.45") |
value | |
06a17c |
VALUE | =VALUE("abc") |
value | |
c31aa3 |
VALUE | =VALUE("TRUE") |
value | |
cce113 |
TEXT | =TEXT(1234.5, "#,##0.00") |
format | 1 |
895f47 |
SUM | =SUM({TRUE,FALSE,TRUE}) |
value | |
daf86f |
SUM | =SUM({1,"2",TRUE}) |
value | |
56f4c2 |
PRODUCT | =PRODUCT({"2","3","4"}) |
value | |
1ae802 |
N | =N({TRUE,FALSE,TRUE}) |
value | 1 |