## Examples

`NUMBER(4.4)`

: `4`

(rounded down) Equivalent to `FLOOR(4.4)`

or `ROUND(4.4)`

). See also: *FLOOR()*, *ROUND()*.

`NUMBER(4.5)`

: `4`

(rounded **DOWN!**) Equivalent to `FLOOR(4.5)`

).

`NUMBER(4.6)`

: `5`

(rounded up) Equivalent to `CEILING(4.6)`

or `ROUND(4.6)`

). See also: *CEILING()*, *ROUND()*.

`NUMBER(4.8)`

: `5`

(rounded up)

`NUMBER("4.2")`

gives `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.

`NUMBER("14.2")`

gives `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.

`NUMBER("Hello!")`

gives `0`

, as the input value in no way resembles a numeric value.

`NUMBER("")`

gives a blank *Number* value.

## Syntax

**NUMBER(** *any-value* **)**

## Argument

*any-value* (any)

## Return 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.

## See Also

*APP()*, *DATE()*, *DATETIME()*, *DECIMAL()*, *TEXT()*, *TIME()*