| % | 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 | ||
| simple | 0 | 0.01 | 0 | #DIV/0! | #N/A | #NAME? | #NULL! | #NUM! | #REF! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0.027 | 0.0354 | 361.92 | 361.93 | 0 | 0.031415 | 361.932 | |
| array | 0 | 0.01 | 0 | #DIV/0! | #N/A | #NAME? | #NULL! | #NUM! | #REF! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0.027 | 0.0354 | 361.92 | 361.93 | 0 | 0.031415 | 361.932 | |
| 0 | 0.01 | 0 | #DIV/0! | #N/A | #NAME? | #NULL! | #NUM! | #REF! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0.027 | 0.0354 | 361.92 | 361.93 | 0 | 0.031415 | 361.932 | ||
| 0 | 0.01 | 0 | #DIV/0! | #N/A | #NAME? | #NULL! | #NUM! | #REF! | #VALUE! | #VALUE! | #VALUE! | #VALUE! | 0.027 | 0.0354 | 361.92 | 361.93 | 0 | 0.031415 | 361.932 | ||
| 40 | 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 | |