3

Why does

="" > 0

Evaluate to TRUE?

And how can I input a value that would evaluate to FALSE that is not a number?

  • 2
    Why? Only the designers of Sheets spec would be able to say for sure, but my guess is they decided to make any string greater than any number. – user79865 Jun 14 '16 at 11:58
4

how can I input a value that would evaluate to FALSE that is not a number?

Use ISNUMBER.

Syntax
ISNUMBER(value)

value - The value to be verified as a number.

*ISNUMBER returns TRUE if this is a number or a reference to a cell containing a numeric value and FALSE otherwise.

0

Multiply by 1 and then evaluate >0.

This may help anyone who wants to have zeroes in the list but still want to evaluate if greater than zero.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.