This information was provided by Claris Corporation on 16 March 1998, and incorporated into Apple Computer's Tech Info Library.
A calculation formula that refers to cells containing text and cells containing numbers will display the #VALUE! error message. This message indicates that the formula is unable to return a number based on text values.