& |
B |
Blank |
Boolean |
Boolean |
Error |
Error |
Error |
Error |
Error |
Error |
Error |
String |
String |
String |
Str Num |
Str Num |
Integer |
Integer |
Zero |
Float |
Float |
|
A |
|
|
TRUE |
FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
Liz |
Doug |
Bob |
2.7 |
3.54 |
2/1/1999 |
2/2/1999 |
0 |
3.1415 |
36193.2 |
|
Blank |
|
|
TRUE |
FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
Liz |
Doug |
Bob |
2.7 |
3.54 |
36192 |
36193 |
0 |
3.1415 |
36193.2 |
|
Boolean |
TRUE |
TRUE |
TRUETRUE |
TRUEFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
TRUELiz |
TRUEDoug |
TRUEBob |
TRUE2.7 |
TRUE3.54 |
TRUE36192 |
TRUE36193 |
TRUE0 |
TRUE3.1415 |
TRUE36193.2 |
Boolean |
FALSE |
FALSE |
FALSETRUE |
FALSEFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
FALSELiz |
FALSEDoug |
FALSEBob |
FALSE2.7 |
FALSE3.54 |
FALSE36192 |
FALSE36193 |
FALSE0 |
FALSE3.1415 |
FALSE36193.2 |
Error |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
Error |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
Error |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
|
Error |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
|
Error |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
|
Error |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
|
Error |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
|
String |
Liz |
Liz |
LizTRUE |
LizFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
LizLiz |
LizDoug |
LizBob |
Liz2.7 |
Liz3.54 |
Liz36192 |
Liz36193 |
Liz0 |
Liz3.1415 |
Liz36193.2 |
String |
Doug |
Doug |
DougTRUE |
DougFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
DougLiz |
DougDoug |
DougBob |
Doug2.7 |
Doug3.54 |
Doug36192 |
Doug36193 |
Doug0 |
Doug3.1415 |
Doug36193.2 |
String |
Bob |
Bob |
BobTRUE |
BobFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
BobLiz |
BobDoug |
BobBob |
Bob2.7 |
Bob3.54 |
Bob36192 |
Bob36193 |
Bob0 |
Bob3.1415 |
Bob36193.2 |
Str Num |
2.7 |
2.7 |
2.7TRUE |
2.7FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
2.7Liz |
2.7Doug |
2.7Bob |
2.72.7 |
2.73.54 |
2.736192 |
2.736193 |
2.70 |
2.73.1415 |
2.736193.2 |
Str Num |
3.54 |
3.54 |
3.54TRUE |
3.54FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
3.54Liz |
3.54Doug |
3.54Bob |
3.542.7 |
3.543.54 |
3.5436192 |
3.5436193 |
3.540 |
3.543.1415 |
3.5436193.2 |
Integer |
2/1/1999 |
36192 |
36192TRUE |
36192FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36192Liz |
36192Doug |
36192Bob |
361922.7 |
361923.54 |
3619236192 |
3619236193 |
361920 |
361923.1415 |
3619236193.2 |
Integer |
2/2/1999 |
36193 |
36193TRUE |
36193FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36193Liz |
36193Doug |
36193Bob |
361932.7 |
361933.54 |
3619336192 |
3619336193 |
361930 |
361933.1415 |
3619336193.2 |
Zero |
0 |
0 |
0TRUE |
0FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
0Liz |
0Doug |
0Bob |
02.7 |
03.54 |
036192 |
036193 |
00 |
03.1415 |
036193.2 |
|
Float |
3.1415 |
3.1415 |
3.1415TRUE |
3.1415FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
3.1415Liz |
3.1415Doug |
3.1415Bob |
3.14152.7 |
3.14153.54 |
3.141536192 |
3.141536193 |
3.14150 |
3.14153.1415 |
3.141536193.2 |
Float |
36193.2 |
36193.2 |
36193.2TRUE |
36193.2FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36193.2Liz |
36193.2Doug |
36193.2Bob |
36193.22.7 |
36193.23.54 |
36193.236192 |
36193.236193 |
36193.20 |
36193.23.1415 |
36193.236193.2 |
|
|
Blank |
|
|
TRUE |
FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
Liz |
Doug |
Bob |
2.7 |
3.54 |
36192 |
36193 |
0 |
3.1415 |
36193.2 |
|
Boolean |
|
TRUE |
TRUETRUE |
TRUEFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
TRUELiz |
TRUEDoug |
TRUEBob |
TRUE2.7 |
TRUE3.54 |
TRUE36192 |
TRUE36193 |
TRUE0 |
TRUE3.1415 |
TRUE36193.2 |
Boolean |
|
FALSE |
FALSETRUE |
FALSEFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
FALSELiz |
FALSEDoug |
FALSEBob |
FALSE2.7 |
FALSE3.54 |
FALSE36192 |
FALSE36193 |
FALSE0 |
FALSE3.1415 |
FALSE36193.2 |
Error |
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
Error |
|
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
#N/A |
|
Error |
|
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
#NAME? |
|
Error |
|
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
#NULL! |
|
Error |
|
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
#NUM! |
|
Error |
|
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
#REF! |
|
Error |
|
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
|
String |
|
Liz |
LizTRUE |
LizFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
LizLiz |
LizDoug |
LizBob |
Liz2.7 |
Liz3.54 |
Liz36192 |
Liz36193 |
Liz0 |
Liz3.1415 |
Liz36193.2 |
String |
|
Doug |
DougTRUE |
DougFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
DougLiz |
DougDoug |
DougBob |
Doug2.7 |
Doug3.54 |
Doug36192 |
Doug36193 |
Doug0 |
Doug3.1415 |
Doug36193.2 |
String |
|
Bob |
BobTRUE |
BobFALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
BobLiz |
BobDoug |
BobBob |
Bob2.7 |
Bob3.54 |
Bob36192 |
Bob36193 |
Bob0 |
Bob3.1415 |
Bob36193.2 |
Str Num |
|
2.7 |
2.7TRUE |
2.7FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
2.7Liz |
2.7Doug |
2.7Bob |
2.72.7 |
2.73.54 |
2.736192 |
2.736193 |
2.70 |
2.73.1415 |
2.736193.2 |
Str Num |
|
3.54 |
3.54TRUE |
3.54FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
3.54Liz |
3.54Doug |
3.54Bob |
3.542.7 |
3.543.54 |
3.5436192 |
3.5436193 |
3.540 |
3.543.1415 |
3.5436193.2 |
Integer |
|
36192 |
36192TRUE |
36192FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36192Liz |
36192Doug |
36192Bob |
361922.7 |
361923.54 |
3619236192 |
3619236193 |
361920 |
361923.1415 |
3619236193.2 |
Integer |
|
36193 |
36193TRUE |
36193FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36193Liz |
36193Doug |
36193Bob |
361932.7 |
361933.54 |
3619336192 |
3619336193 |
361930 |
361933.1415 |
3619336193.2 |
Zero |
|
0 |
0TRUE |
0FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
0Liz |
0Doug |
0Bob |
02.7 |
03.54 |
036192 |
036193 |
00 |
03.1415 |
036193.2 |
|
Float |
|
3.1415 |
3.1415TRUE |
3.1415FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
3.1415Liz |
3.1415Doug |
3.1415Bob |
3.14152.7 |
3.14153.54 |
3.141536192 |
3.141536193 |
3.14150 |
3.14153.1415 |
3.141536193.2 |
Float |
|
36193.2 |
36193.2TRUE |
36193.2FALSE |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
36193.2Liz |
36193.2Doug |
36193.2Bob |
36193.22.7 |
36193.23.54 |
36193.236192 |
36193.236193 |
36193.20 |
36193.23.1415 |
36193.236193.2 |
|
400 |
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
Success |
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|