Quote Originally Posted by SDruley
How is this possible?
A Formula Null is a 0 Length Text String and Text > Number.

For a numeric comparison where Nulls/Text values are a possibility you can use N or SUM, eg:

=N(A1)>2

=SUM(A1)>2
which will return 0 for the Null/Text value whilst avoiding explicit coercion