Works: Blank Cell Does Not Equal Zero or Text

When you compare values in a spreadsheet or database, Works treats a blank cell as a zero, but does not treat a text entry as a numeric zero. For example, the formula will return a True if cells A1 and B1 are blank or contain a zero. The formula will return a False if cells A1 and B1 contain text and either a zero or are blank.

When you perform other types of comparisons, greater than(>), less than (<), or not equal (<>), a text entry is treated as not equal (<>) to numeric values, zeros, or blank cells. Earlier versions of Works for Windows treated text entries as equivalent to zero values.