4 (rounded DOWN!) Equivalent to
5 (rounded up)
0. AppSheet recognizes quoted raw text values in certain formats as Date, DateTime, or 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 Date, DateTime, or 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 value.
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 Number value.