* |
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 |
|
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Boolean |
TRUE |
0 |
1 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
2.7 |
3.54 |
36192 |
36193 |
0 |
3.1415 |
36193.2 |
Boolean |
FALSE |
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
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 |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
String |
Doug |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
String |
Bob |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
Str Num |
2.7 |
0 |
2.7 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
7.29 |
9.558 |
97718.4 |
97721.1 |
0 |
8.48205 |
97721.64 |
Str Num |
3.54 |
0 |
3.54 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
9.558 |
12.5316 |
128119.7 |
128123.2 |
0 |
11.12091 |
128123.9 |
Integer |
2/1/1999 |
0 |
36192 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97718.4 |
128119.7 |
1.31E+09 |
1.31E+09 |
0 |
113697.2 |
1.31E+09 |
Integer |
2/2/1999 |
0 |
36193 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97721.1 |
128123.2 |
1.31E+09 |
1.31E+09 |
0 |
113700.3 |
1.31E+09 |
Zero |
0 |
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Float |
3.1415 |
0 |
3.1415 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
8.48205 |
11.12091 |
113697.2 |
113700.3 |
0 |
9.869022 |
113700.9 |
Float |
36193.2 |
0 |
36193.2 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97721.64 |
128123.9 |
1.31E+09 |
1.31E+09 |
0 |
113700.9 |
1.31E+09 |
|
|
Blank |
|
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Boolean |
|
0 |
1 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
2.7 |
3.54 |
36192 |
36193 |
0 |
3.1415 |
36193.2 |
Boolean |
|
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
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 |
|
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
String |
|
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
String |
|
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
Str Num |
|
0 |
2.7 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
7.29 |
9.558 |
97718.4 |
97721.1 |
0 |
8.48205 |
97721.64 |
Str Num |
|
0 |
3.54 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
9.558 |
12.5316 |
128119.7 |
128123.2 |
0 |
11.12091 |
128123.9 |
Integer |
|
0 |
36192 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97718.4 |
128119.7 |
1.31E+09 |
1.31E+09 |
0 |
113697.2 |
1.31E+09 |
Integer |
|
0 |
36193 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97721.1 |
128123.2 |
1.31E+09 |
1.31E+09 |
0 |
113700.3 |
1.31E+09 |
Zero |
|
0 |
0 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Float |
|
0 |
3.1415 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
8.48205 |
11.12091 |
113697.2 |
113700.3 |
0 |
9.869022 |
113700.9 |
Float |
|
0 |
36193.2 |
0 |
#DIV/0! |
#N/A |
#NAME? |
#NULL! |
#NUM! |
#REF! |
#VALUE! |
#VALUE! |
#VALUE! |
#VALUE! |
97721.64 |
128123.9 |
1.31E+09 |
1.31E+09 |
0 |
113700.9 |
1.31E+09 |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|