4 (rounded DOWN!) Equivalent to
5 (rounded up)
0. AppSheet recognizes quoted raw text values in certain formats as
Time values. In this example
"4.2" is recognized as the date, April 2 (of the current year). A
Date value has no
Number equivalent, so
0 is returned. This (mis-)interpretation of the input only affects raw text values; an input from a column value or the result of another expression would not be so affected.
14. Unlike the preceding example, the quoted raw text value of
"14.2" does not correspond to a valid
Time value, allowing
NUMBER() to work with the given text and to give the expected result.
0, as the input value in no way resembles a numeric value.
NUMBER("") gives a blank
NUMBER( any-value )
Number: The integer equivalent of
any-value if a recognizable number, or
0 if not. If
any-value is blank (e.g.,
""), the result will be a blank